View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Don Guillett[_4_] Don Guillett[_4_] is offline
external usenet poster
 
Posts: 2,337
Default 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