| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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. |
|
#2
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Why Word 2007 mail merge does not retain number format from Excel | Mailmerge | |||
| How do I get Word to retain Excel formatting, eg zip code, ssn? | Mailmerge | |||
| Insert Excel cells in MS-Word and retain Excel Functionalitity? | Tables | |||
| How to copy linked Excel and Word files and retain links | Microsoft Word Help | |||
| How do I retain formatting from an Excel Data File to a Word Merg. | Microsoft Word Help | |||
Linear Mode
