View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Niek Otten Niek Otten is offline
external usenet poster
 
Posts: 3,440
Default How do I change Excel default number?

Office button (large round, top left)Excel OptionsAdvanced tabUncheck
"Automatically insert a decimal point"

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"PatrickR" wrote in message
...
Recently upgrade to Excel 2007. When I type in 125000 and press enter key
it
changes to 12.5 and when I type in 5000 it gives me 0.5 My question is
how
do I change to setup so that what ever I typed in it stay that way? Thank
you for your help in advance.