Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

Format exact excel cell data

Posted on 2015-01-29
2
Medium Priority
?
59 Views
Last Modified: 2015-01-29
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
Comment
Question by:Bob Schneider
2 Comments
 
LVL 36

Accepted Solution

by:
Norie earned 2000 total points
ID: 40577460
You can add this switch to the mail merge field.

\@ "HH:mm"
0
 

Author Closing Comment

by:Bob Schneider
ID: 40577536
Thank you.
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Some code to ensure data integrity when using macros within Excel. Also included code that helps secure your data within an Excel workbook.
How to get Spreadsheet Compare 2016 working with the 64 bit version of Office 2016
This Micro Tutorial will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa‚Ķ

564 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question