I have a large list of "random" numbers from 1 to 250000 I need to format these so that they are all 6 digits long by adding leading zeros where necessary.
I have searched the information available to me but apart from TRIM to remove leading zeros I can't find anything that even mentions leading zeros. Has anyone some advice I can use.
John
Hi right click format>custom> 0000000 (put n no of zeros)
☚ Click ★ just below left if it helps, Boo?ath?
Depends if you just want them to show six digits or whether you want them to physically have six digits, for example, if you want to create a .csv file with these numbers.
If you just want to display them, use a custom format with six zeros. If you want to force the digits, you could use TEXT, for example, =TEXT(H1,"000000"). That would, of course, need to be in a separate column ... but you could hide the original column.
Regards, TMS
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Thanks for your interest. I need to go the TEXT way. It was the actual format code ie "000000" that I needed and did not know. Thanks for your help
John
You're welcome. Thanks for the rep.
Weather's brightening up a bit
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks