Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
cell format question
What causes this:
Format a column as text Enter into first cell 1257470 then next cell 12574700 then next cell 125747000 then next cell 1257470000 then next cell 12574700000 then next cell 125747000000, but it changes it to 1.25747E+11 What is going on with this??? Also, in a text cell, I enter 08-812000-02 then, go to edit replace and try to replace the '-' with nothing but when it does, it changes the cell to 881200002 - it takes the dashes, but it also takes off the leading zero??? WHY? Any help with these two questions would be greatly appreciated. ga George Applegate |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to convert a month to a quarter ...... | New Users to Excel | |||
Cell References | Excel Discussion (Misc queries) | |||
Cell format question? (example 0002) | Excel Discussion (Misc queries) | |||
Cond. Format & Absolute Cell Reference Question | Excel Discussion (Misc queries) | |||
can't format cell - have tried unlocking and unprotecting | Excel Discussion (Misc queries) |