View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Don Guillett Don Guillett is offline
external usenet poster
 
Posts: 10,124
Default 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.