Format cell, number tab, custom format:
"'%"0000000"%'"
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"NeedExcelHelp" wrote:

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?