View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Peo Sjoblom Peo Sjoblom is offline
external usenet poster
 
Posts: 3,268
Default 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