| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cell format has suddenly changed in all new spread sheets
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 -- Ian D Anderson |
| 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
