| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
default format for Excel numbers
Bringing up a new sheet and typin in the number 262 in any cell, gets entered
as 2.62; as if the entered nuymber is divided by 100. How do I change it back to normal? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
default format for Excel numbers
Goto the menu ToolsOptionsEdit tabuncheck Fixed decimal placesOK
-- Biff Microsoft Excel MVP "Chuck G" <Chuck wrote in message ... Bringing up a new sheet and typin in the number 262 in any cell, gets entered as 2.62; as if the entered nuymber is divided by 100. How do I change it back to normal? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
default format for Excel numbers
Tools Options Edit Clear the fixed decimal places checkbox
If this post helps click Yes --------------- Jacob Skaria "Chuck G" wrote: Bringing up a new sheet and typin in the number 262 in any cell, gets entered as 2.62; as if the entered nuymber is divided by 100. How do I change it back to normal? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
default format for Excel numbers
Hi,
In 2007 press Alt+1, choose Advanced, uncheck Automatically insert a decimal point -- If this helps, please click the Yes button. Cheers, Shane Devenshire "Chuck G" wrote: Bringing up a new sheet and typin in the number 262 in any cell, gets entered as 2.62; as if the entered nuymber is divided by 100. How do I change it back to normal? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I change default row numbers in Excel ? | Excel Worksheet Functions | |||
| Default Date Format in Excel | Excel Discussion (Misc queries) | |||
| Excel Default Format | Excel Discussion (Misc queries) | |||
| Default date format in excel | Excel Discussion (Misc queries) | |||
| how do i set a default date format in Excel | Excel Discussion (Misc queries) | |||
Linear Mode
