| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Numbers changed into zeros
I have a problem that i had phone numbers in excel columns. After some time I
have opened the file and see that Excel has changed the phone numbers into the format like 4.48E+11 and in the formula bar it shows like 448000000000. It means that Excel has replaced the last 9 digits with zeros. This has happened to majority of cells within one worksheet while yet there are certain cells which were not affected by this problem and they are showing the original numbers correctly. Please help me how can i recover my original numbers and why this problem has happened. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| col of minus numbers changed to plus numbers | Excel Worksheet Functions | |||
| column changed to numbers | Excel Discussion (Misc queries) | |||
| sum up a dynamic-changed list of numbers | Excel Discussion (Misc queries) | |||
| Add Zeros to Numbers | Excel Discussion (Misc queries) | |||
| Can the preset numbers in the column be changed? | Excel Discussion (Misc queries) | |||
Threaded Mode
