View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
needexcelhelp needexcelhelp is offline
external usenet poster
 
Posts: 5
Default Custom Format for cells

Hi, I have a list of numbers that look like this list:

3564
9299
16743
23
294

I need to change them so they all look like this:

'%0003564%'
'%0009299%'
'%0016743%'
'%0000023%'
'%0000294%'

How do I do this?