| 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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Change the "Insert Function" display for mail merge
Mail Merge is of course MS Word.
If you are only comfortable in Excel interfacing to Mail Merge the easies way is to Create a helper column that has the value you want as text =TEXT(B4,"hh:mm:ss AM/PM") If you are comfortable in MS Word as well there are other solutions, which you will find in the links to MS Word oriented material see... For more information on Mail Merge see http://www.mvps.org/dmcritchie/excel/mailmerg.htm --- HTH, David McRitchie, Microsoft MVP - Excel My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "Beach Lover" wrote in message ... 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. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Change the "Insert Function" display for mail merge
You may need to try a helper column with =TEXT(A1,"h:mm AM/PM")
-- David Biddulph "Beach Lover" wrote in message ... 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. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Change the "Insert Function" display for mail merge
This worked, thank you!
"David McRitchie" wrote: Mail Merge is of course MS Word. If you are only comfortable in Excel interfacing to Mail Merge the easies way is to Create a helper column that has the value you want as text =TEXT(B4,"hh:mm:ss AM/PM") If you are comfortable in MS Word as well there are other solutions, which you will find in the links to MS Word oriented material see... For more information on Mail Merge see http://www.mvps.org/dmcritchie/excel/mailmerg.htm --- HTH, David McRitchie, Microsoft MVP - Excel My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "Beach Lover" wrote in message ... 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. |
| Reply |
| 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 | |||
Linear Mode
