ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Format cell with 18 characters (https://www.excelbanter.com/excel-discussion-misc-queries/154292-format-cell-18-characters.html)

Format cell with 18 characters

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

Peo Sjoblom

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





All times are GMT +1. The time now is 01:26 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com