Thread
:
Custom Format for cells
View Single Post
#
1
Posted to microsoft.public.excel.misc
needexcelhelp
external usenet poster
Posts: 5
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?
Reply With Quote
needexcelhelp
View Public Profile
Find all posts by needexcelhelp