|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
May 12th 18, 01:32 AM
|
|||
|
|||
Retain / Reformat negative time from Excel to Word
Hi There,
Really need some advice here after cracking my head and searching for a long time. I have a negative time displayed in my excel sheet (e.g -01:22 mm:ss) which I would like to retain the format when I do a mail merge on MS word. However, the time gets converted to 01:22. I have tried to add the '-' sign at the front using an If .... Else... statement when the value is Less Than '0'. Both methods do not work out. Thank you. 
|
| Ads | |
|
#2
May 30th 19, 10:46 AM
|
|||
|
|||
|
Hello, I have a suggestion for you. You can click to "Time" box on the tool bar and check for other type of time. If it doesn't have the one you need, you can create one. Thank you.
This is my website hill climb racing, please pass by to support if you have times.
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Why Word 2007 mail merge does not retain number format from Excel | sretep | Mailmerge | 1 | June 6th 09 02:55 PM |
| How do I get Word to retain Excel formatting, eg zip code, ssn? | soxn4n04 | Mailmerge | 1 | December 1st 05 05:52 AM |
| Insert Excel cells in MS-Word and retain Excel Functionalitity? | David in NM | Tables | 1 | October 20th 05 09:52 PM |
| How to copy linked Excel and Word files and retain links | Phil | Microsoft Word Help | 1 | May 8th 05 07:51 PM |
| How do I retain formatting from an Excel Data File to a Word Merg. | Pookas | Microsoft Word Help | 5 | March 14th 05 11:32 PM |
Linear Mode
