help with a mail merge

akim281 · #1 02-05-2010, 10:17 AM

I have searched and can not find a solution to my problem.

I have an Excel spreadsheet that has columns of time formatted in the [h]:mm format. I am trying to do a mail merge and bring them over to Word. But when I do this it does not keep the same [h]:mm format.

For example, in Excel I have 25:57. When moved over to Word I get this
1/1/1900 1:57:00 AM.

Can anyone help??

zyzzyva57 · #2 02-05-2010, 01:58 PM

Does this help?

akim281 · #3 02-05-2010, 02:54 PM

actually it did! thanks so much

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Mail Merge help	dkwi04	Mail Merge	1	12-22-2009 11:23 PM
Mail Merge	hiteshkataria	Mail Merge	4	11-06-2009 05:11 AM
mail merge	Anthony	Outlook	1	09-29-2009 06:09 PM
problem in Mail merge	rjagathe	Mail Merge	0	08-12-2009 08:25 AM
Mail Merge	Mohanss82	Mail Merge	0	01-21-2009 12:29 PM