Link to home
Start Free TrialLog in
Avatar of zimmer9
zimmer9Flag for United States of America

asked on

How to expand an Excel 2003 macro to bypass column values that are empty?

I am working with Excel 2003.

How would you revise the following macro to bypass rows that don't have a value?

I want to convert a Column with (date and time) to just display the date in the format

mm/dd/yyyyy

I use a macro as follows:

=MONTH(A2) & "/" & DAY(A2) & "/" & YEAR(A2)

Attache is a sample file:
Supress.xls
SOLUTION
Avatar of felixdsouza
felixdsouza
Flag of India image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial