Thread
:
Macro Help replacing dropped zeros
View Single Post
#
2
Posted to microsoft.public.excel.misc
Ken Johnson
external usenet poster
Posts: 1,073
Macro Help replacing dropped zeros
Hi,
Will a worksheet formula do?...
=REPT(0,9-LEN(A1)) & A1
I don't think you have to bother with the apostrophe.
Ken Johnson
Reply With Quote
Ken Johnson
View Public Profile
Find all posts by Ken Johnson