View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default typing #1 becomes #10

One more to check
Tools|Options|Edit tab|Uncheck fixed decimals



tenbobblind wrote:

When i go to type the number 1 in a spreadsheet it comes up as a ten, or 2
becomes 20!!!


--

Dave Peterson