Forum Discussion
convert numbers to text and maitain number of digits including preceeding zeros
HI I need to convert a column of numbers containing three digits (ie 001, 002, 003) into text, and maintain the zeros preceding the the non-zero digits. How can I do this? OR I have two columns...
This formula might help you :).
=TEXT(A1,"00000")
Keeping leading zeros and large numbers
If I may add, as Mr. Hans Vogelaar (@Hans Vogelaar) has already informed you, a more detailed description, if possible with a file or photos, would be of great advantage in order to get a quick and precise solution proposal. Here is a link with information on how you can get a quick and precise solution here in the forum.
Welcome to your Excel discussion space!
Thank you for your understanding and patience
I know I don't know anything (Socrates)