| Home |
| Search |
| Today's Posts |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cell format has suddenly changed in all new spread sheets
Many thanks for your reply!
-- Ian D Anderson "Gord Dibben" wrote: Andy ToolsOptionsEdit. Uncheck the option at "Fixed Decimal Places" Gord Dibben MS Excel MVP On Sat, 28 Oct 2006 01:17:02 -0700, Andy wrote: When I used to entre a number in my spread sheets as 120 it would read 120. now it reads 1.2 and the same for any other numbers I enter. 150 is now 1.5 etc. I cant understand how this has suddely changed. I've tried the format options but I cant stop this happening. Any ideas please |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| copy with format | New Users to Excel | |||
| Changed referenced cell between sheets | Excel Discussion (Misc queries) | |||
| Cell data format | Excel Discussion (Misc queries) | |||
| Copy cell format to cell on another worksht and update automatical | Excel Worksheet Functions | |||
| can't format cell - have tried unlocking and unprotecting | Excel Discussion (Misc queries) | |||
Threaded Mode
