Thread
:
Format cell with 18 characters
View Single Post
#
2
Posted to microsoft.public.excel.misc
Peo Sjoblom
external usenet poster
Posts: 3,268
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 With Quote
Peo Sjoblom
View Public Profile
Find all posts by Peo Sjoblom