View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
rexie3 rexie3 is offline
external usenet poster
 
Posts: 14
Default How do I create a macro to add zeros in front of a value?

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.