Software

Ask something
Question Locked

date format problem

0 helpful
4 replies

by vimalkumar.mishra

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Sir,

i am using mail merge in word but datasource in excel . but there is date conversion problem. so please tell me how to convert the date formatin merged data.

Regards
Vimal

Payroll manager

4 replies

by jalford12

Since Excel is capable of stuffing up dates
without any effort whatsoever, I suggest
passing the serial date/time in your merge
then formatting when it arrives where you
want to use it.

In Excel use DATEVALUE

Hope this helps

by thumbsup2

Either on your merge template where you can see the fields or during the merge itself, use a picture switch on the date field to tell it how to format that field. Field formating switches can all be found in the built in HELP.

This discussion is closed to new replies.