Link to home
Start Free TrialLog in
Avatar of Bob Schneider
Bob SchneiderFlag for United States of America

asked on

Don't Convert Time to Time-of-Day in Mail Merge

I am trying to create labels with data such as 2:29.  I keep getting 2:29:00 AM when I do the mail merge.  If I go back to Excel and save as text I get a funky decimal.  I also tried to do a Paste Special to a separate column but got the same issue.

Any help would be much appreciated.
SOLUTION
Avatar of Bill Prew
Bill Prew

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