View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
DTTODGG DTTODGG is offline
external usenet poster
 
Posts: 74
Default left fill Excel numbers

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