View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
cew47 cew47 is offline
external usenet poster
 
Posts: 2
Default Automatic conversion to scientific numbers

This appears to have fixed it. Thank you so much!!

"Toppers" wrote:

Try:

Tools=Options=Edit and uncheck "Fixed Decimal places"

"cew47" wrote:

I am trying to create a simple spreadsheet with columns of numbers. I have
formatted each column to a number with no decimal points. However, when I
enter a number, whether it be 1, 2, 3 or 4 digits long, Excel keeps throwing
in trailing zeros, which then returns the scientific value. I have gone back
in and selected the format as Number again and nothing works. Any
suggestions?