Excel 2003 into Excel 2010 Are Not Correct

Just one reason WHY I HATE MICROSOFT WITH THE WHITE-HOT FURY OF A THOUSAND SUNS!!!!!!!!!!!!!!!!!!!!!!!

They hid all the features of the old programs and added NOTHING OF VALUE.

So, you are forced to learn it all over again, for no reason.

There are conversion programs out there, and I think there's a way to read older files with 2010, but I don't know how to use them.

I do know that if you send a 2010 file to someone with 2003, they have to convert it or they can't read it at all.

Migrating to Excel 2010 from Excel 2003 - Excel - Office.com

Microsoft Office Compatibility Pack for Word, Excel, and PowerPoint ...

Excel Converter - Download

Good luck.

Remember when you had a choice. 123, Quarto etc. Always like 123 better then all the others. But when you can buy all of the lawyers needed to keep the anti-trust folks at bay, this is what you get. Just saying!

Borland (Corel) Quattro Pro, Lotus 123, MS Excel, ...

ahh the good old days

There are new options out there:

http://www.openoffice.org/
https://www.libreoffice.org/

Regarding MS products, I prefer NOT to give away any more of my hard earned dollars to billionaires just so I can become one of their beta testers.

Haven't tried the Windows ports of Open Office / Libre Office, but the native Linux versions work very well and provide numerous file save/conversion formats.

Those constrained by company mandate to use MS Office at work should do so. However, I don't understand why any "home" users would pay for MS Office when there are free open-source office suites with 99% of the same features.

I have Open Office, at home, and it works just fine.

I have Open Office at home and it mostly works OK. However, once I tried to fit a curve to some data in a spreadsheet, using, if I remember correctly, a logarithmic curve and found that the result was totally different from the result that Excel had been giving me. Someone told me not to assume that Excel was right which I suppose was good advice, but have not had time to really investigate this and figure out where the problem lies.

I also found some other spreadsheet features missing with open office, so I stopped using it.

In my house Mr Gates is known as "Evil Bill" for inflicting has software on the world.

That said, I live close to Liverpool where the School of Tropical Medicine has been given £30m from the Melissa & Bill Gates Foundation to further it's research into tropical disease.

Gates is a brilliant salesman, with a lousy product, but he has a heart and a conscience, so he can't be all bad. If he is donating your hard earned $ to do some good, it might make you feel better about using his crappy software.

Visi-Calc. Of course I had the BIG 512 K of memory, so It worked good for what I was doing back then. -- JHF

You think YOU hate Microsoft?

http://www.popsci.com/technology/article/2013-08/watch-homemade-coilgun-destroy-laptop

I'm wondering if using Google Docs to save/open files would help. If they saved the file as a google spreadsheet and sent it to you, could you then open it and read it properly?

A few years ago I had some strange Excel formula problems as well. In my case the imported numbers had a blank space or a control character hidden in the cell. For the larger data blocks I cut & pasted the numbers into a "simple" text editor, edited the number series to remove any extraneous characters/spaces, cut & pasted it back into the spreadsheet, and all calculations resumed as normal.

You might like to try it with this non-Microsoft version of Office (Excel, Word Powerpoint equivalents)

http://ksosoft.com/product/office-pro.html?gclid=CIuesaWA9LgCFWxIpgodnBkAdA

It works perfectly with xp and Win7

Excel 2010 can save and open in many different formats, have you tried an earlier one?

Also, I have the feeling that the people who compiled the sheets did not test what they had done and are probably at fault.

You could ask them (if they say that everything is OK on their computer, to load and save in another format (after testing that what they say is true of course!)....

They should assist you. If they don't want to help, never use them again.

i mean WTSh cares call microsoft support its listed in help file or at their website - the service used to be paid by you when you brought their PoSh

end , over & out

You can convert the data entries to a number.

You will no doubt seee the little green triangle in top left corner of the cell. See these images. Ask if you do not follow. (I just dont have time to type a long explantion at present)

Hover over the !

then select the drop down triangle...

You can first select a range of cells to convert...

Then select "Convert to Number" option...

Hope that this may help.

Obviously its easier to save it in a suitable format to begin with, but this may help you resolve the issue if you hjave no control over how the data comes to you.

If you have Microsoft Access installed, you can try importing the data into Access and then export it back into Excel.

EXCEL should ask you when exiting a workbook whether you want to convert the file.

YOu get a message to the effect that XL will recalculate formulas from earlier versions. This should solve the problem, open the file and then close it, or close it after a minor change. You should get the convert question - answer yes and the file should open next time as fully functional.

Note this is a one way function, you cannot give your coleagues the changed version and expect them to open it. if this is a requirement, then you will have to run an older copy of XL just to maintain compatibility with them. I have several versions of XL on my system, they coexist well, you have only to be sure by using "open with" that you run the right version for a given file.

Hope that helps.