| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to format time in decimal format & calculate time | Excel Discussion (Misc queries) | |||
| How to format time in decimal format & calculate time | Excel Discussion (Misc queries) | |||
| How to format time in decimal format & calculate time | Excel Discussion (Misc queries) | |||
| How to type format time in decimal format & calculate time | Excel Discussion (Misc queries) | |||
| Remove time from a date and time field? Format removes the displa. | Excel Worksheet Functions | |||
Linear Mode
