Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Format cell with 18 characters
Hi,
I have a number with 18 characters (951019210948009630) and I would like to change the last three characters from 630 to 520. I try to make this change but for some reasons the last 3 characters automatically change to 000. (951019210948009000). Does somebody know why I can not change the number? Thank you, Zsuzsanna |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Format cell with 18 characters
Preformat as text or type an apostrophe before you type in the number, Excel
has a limit of 15 digits -- Regards, Peo Sjoblom "Format cell with 18 characters" <Format cell with 18 wrote in message ... Hi, I have a number with 18 characters (951019210948009630) and I would like to change the last three characters from 630 to 520. I try to make this change but for some reasons the last 3 characters automatically change to 000. (951019210948009000). Does somebody know why I can not change the number? Thank you, Zsuzsanna |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Format cells for special characters | New Users to Excel | |||
Format cells for special characters | New Users to Excel | |||
format cell to place colon btw every 2 alphanumeric characters | Excel Worksheet Functions | |||
Extra characters exported in unicode(.txt) format | Excel Discussion (Misc queries) | |||
How to save Japanese characters in CSV format of Excel ? | Excel Discussion (Misc queries) |