Thread
:
left fill Excel numbers
View Single Post
#
2
Posted to microsoft.public.excel.programming
Don Guillett[_4_]
external usenet poster
Posts: 2,337
left fill Excel numbers
easiest might be to format 00000
--
Don Guillett
SalesAid Software
"DTTODGG" wrote in message
...
Hi;
I have varying length "numbers" in a text cell and I would like to make
them
all the same length. How can I Left-Fill with Zeros?
ie.
2
121
98237
I would like:
00002
00121
98237
Thanks in advance
Reply With Quote
Don Guillett[_4_]
View Public Profile
Find all posts by Don Guillett[_4_]