| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I change Excel default number?
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
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I change Excel default number?
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
|
|||
|
|||
|
How do I change Excel default number?
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 | |
|
|
Similar Threads
|
||||
| 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 | |||
Linear Mode
