time format from hh:mm:ss to h:mm
 

I have been trying forever and no luck at all!!!
I have changed the the whole column under format cell/Number/Category/time
and selected 13:30 (english USA) When I then try to do a mail merge in word
2003 the merged field still comes up hh:mm:ss which I don't want???
Any help greatly appreaciated.

time format from hh:mm:ss to h:mm
 

Unfortunately, mail merge doesn't look at the cell's format, only its number
type.

Either create a text field, using a formula like:
=text(a1,"hh:mm")

or specify the format in your Word document.

Regards,
Fred

"Diana" wrote in message
...
I have been trying forever and no luck at all!!!
I have changed the the whole column under format cell/Number/Category/time
and selected 13:30 (english USA) When I then try to do a mail merge in
word
2003 the merged field still comes up hh:mm:ss which I don't want???
Any help greatly appreaciated.