View Single Post
 
Old 12-12-2013, 03:37 PM
SteveWcg SteveWcg is offline Windows 7 64bit Office 2013
Novice
 
Join Date: Jun 2013
Location: Sydney Australia
Posts: 22
SteveWcg is on a distinguished road
Default

I can't really replicate it but it sounds like excel is converting the number to scientific formula on saving it. This can happen when you have numbers as text and you choose the convert to number option in the drop down option, see picture.


Before you save the file select the numbers and convert them to text. If you save them in scientific format it looks like the before in the example but if you save them as numbers it looks like the after
Attached Images
File Type: png tonum_before.png (7.4 KB, 9 views)
File Type: png tonum_after.png (2.9 KB, 15 views)
File Type: png example.png (9.8 KB, 9 views)
Reply With Quote