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 |
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