Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 61
  • Last Modified:

Format exact excel cell data

I have a column that has data such as 4:20, 1:00, 3:14, 13:25, etc and it looks fine in excel but when I try to use it as mail merge it converts to 4:20:00 AM and it converts 13:25 to 1:25:00 PM.  How can I maintain the exact cell format when using in mail merge?

Thank you very much!
0
Bob Schneider
Asked:
Bob Schneider
1 Solution
 
NorieVBA ExpertCommented:
You can add this switch to the mail merge field.

\@ "HH:mm"
0
 
Bob SchneiderCo-OwnerAuthor Commented:
Thank you.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now