View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.setup
Niek Otten Niek Otten is offline
external usenet poster
 
Posts: 3,440
Default Stop Excel from converting integers into decimals?

ToolsOptionsEdit tab, Uncheck Fixed Decimal

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"mcwilljg" wrote in message ...
| Excel has suddenly begun converting all numerical entries to 2 decimal place
| numbers. Example 123 -1.23 In order to get 123 one must entr "123." or
| 12300" This seems to be stuck in some accounting or business formatting. It
| just started and I can't change it. Any help?