Thread
:
How do I create a macro to add zeros in front of a value?
View Single Post
#
2
Posted to microsoft.public.excel.worksheet.functions
Don Guillett
external usenet poster
Posts: 10,124
How do I create a macro to add zeros in front of a value?
an easy way is to custom format to the number of 0's desired IF they are the
same length.
000000000000
--
Don Guillett
SalesAid Software
"rexie3" wrote in message
...
PLEASE SOMEONE HELP ME!!!
I have to add zeros to over 61,000 line items in excel. I need to know
how
to create a macro that will enable me to select a range within the same
column and have zeros added to the the numbers in the cell.
I would be eternally greatful.
Thanking you in advance.
Reply With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett