#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
|
||||
|
||||
Cross-posted at: https://www.techsupportforum.com/for...t-1227928.html
For cross-posting etiquette, please read: http://www.excelguru.ca/content.php?184
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
Tags |
negative time mail merge |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How does Excel put values on negative degree(s)? | JUSTIN CMM | Excel | 1 | 01-14-2016 12:41 AM |
Excel VBA to convert number to negative | dakm63 | Excel Programming | 1 | 05-26-2015 10:49 AM |
Copying and pasting acount data into Excel as text will not reformat to a number or currency | ncbergst | Excel | 3 | 09-04-2014 11:29 AM |
How to copy linked Excel and Word files and retain links | ashleynpeters1 | Word | 1 | 05-30-2013 02:25 PM |
Custom formatting to make negative numbers show w/o negative sign on charts | todor | PowerPoint | 3 | 01-16-2013 03:45 AM |