Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Word > Mail Merge

Reply
 
LinkBack Thread Tools Display Modes
  #1  
Old 05-12-2018, 01:27 AM
Warrick Warrick is offline Windows 10 Office 2016
Novice
 
Join Date: May 2018
Posts: 1
Warrick is on a distinguished road
Default 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.
Reply With Quote
  #2  
Old 05-14-2018, 09:55 PM
macropod's Avatar
macropod macropod is offline Windows 7 64bit Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 17,523
macropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to behold
Default

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
[MS MVP - Word]
Reply With Quote
Reply

Tags
negative time mail merge

Thread Tools
Display Modes


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


All times are GMT -7. The time now is 01:12 PM.


Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
MSOfficeForums.com is not affiliated with Microsoft