| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Change the "Insert Function" display for mail merge
I have entered times into a spreadsheet which have been formatted to hh:mm.
They show up in the cells correctly, but in the function line (fx) they show up as hh:mm:ss AM or PM, respectively. When I do a mail merge, the time that is brought into the merged document is what is showing in the function line. How do I get it to bring the data that is being displayed in the cell? Example: 6:00 PM shows in cell.......06:00:00 PM shows in the function line and this is what gets merged into the Word document. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Display Date that does not change everyday. | Excel Discussion (Misc queries) | |||
| change display font to actual selected font | Excel Discussion (Misc queries) | |||
| Different graphic for each record in mail merge document | Charts and Charting in Excel | |||
| How do I change the display of a negative number to just read 0? | Excel Discussion (Misc queries) | |||
| Combine & Display “Fixed” & “Automatically Updated” Date Parts | Excel Worksheet Functions | |||
Threaded Mode
