• Retain / Reformat negative time from Excel to Word

    From Warrick@21:1/5 to All on Sat May 12 01:32:31 2018
    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

    Thank you.

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)