Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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. |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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. |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Wonderful, I learned something new today. Thank you very much Niek
"Niek Otten" wrote: 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. |
#4
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
In Excel 2003 it is Tools/ Options/ Edit/ Fixed Decimal places
Converting 2003 to 2007, the equivalent of Tools/ Options is Office/ Excel Options. http://office.microsoft.com/en-us/ex...100870371033#3 -- David Biddulph "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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Is it possible to change the default number format in Excel? | Excel Discussion (Misc queries) | |||
Excel should allow me to change default number formats | Excel Discussion (Misc queries) | |||
How do you change the excel number default settings? | Excel Discussion (Misc queries) | |||
How do I change the default number format in Excel? | Excel Discussion (Misc queries) | |||
How do I change the default number format in excel? | Excel Worksheet Functions |