 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Word / Mailmerge and Fax / February 2004Time formula error
After entering some times in an Excel spreadsheet, formatting the "TIME" column under the category of Time and the "1:30 PM" Type and merging into a Word document, the time shows as 1:30:00 PM. Does anyone know how to get rid of the seconds indication? I noticed that MS shows this was an issue with MS Works (see knowledge base 239208) but with little success to a fix. Any suggestions are greatly appreciated. Thx, Steve You might want to ask in an Excel group rather than a Word group.  SignatureCharles Kenyon See the MVP FAQ: <URL: http://www.mvps.org/word/> which is awesome! --------- --------- --------- --------- --------- --------- This message is posted to a newsgroup. Please post replies and questions to the newsgroup so that others can learn from my ignorance and your wisdom. > After entering some times in an Excel spreadsheet, > formatting the "TIME" column under the category of Time [quoted text clipped - 10 lines] > Thx, > Steve Steve, Use Alt=F9 to toggle on the field codes and add the following formatting switch inside the closing } of the mergefield in the mailmerge main document. \@ "h:mm AM/PM" SignaturePlease post any further questions or followup to the newsgroups for the benefit of others who may be interested. Unsolicited questions forwarded directly to me will only be answered on a paid consulting basis. Hope this helps Doug Robbins - Word MVP > After entering some times in an Excel spreadsheet, > formatting the "TIME" column under the category of Time [quoted text clipped - 10 lines] > Thx, > Steve Go to word help and General Switches. It will tell you how to get rid of this in a merge document.Mary >-----Original Message----- >After entering some times in an Excel spreadsheet, [quoted text clipped - 12 lines] >Steve >.
|
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.