Thread
:
Macro Help replacing dropped zeros
View Single Post
#
3
Posted to microsoft.public.excel.misc
Ken Johnson
external usenet poster
Posts: 1,073
Macro Help replacing dropped zeros
If I'm wrong about the apostrophe then ="'" & REPT(0,9-LEN(A1)) &A1
Ken Johnson
Reply With Quote
Ken Johnson
View Public Profile
Find all posts by Ken Johnson