Microsoft Office Forums Retain / Reformat negative time from Excel to Word

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 05-12-2018, 01:27 AM
Warrick Warrick is offline Retain / Reformat negative time from Excel to Word Windows 10 Retain / Reformat negative time from Excel to Word Office 2016
Novice
Retain / Reformat negative time from Excel to Word
 
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 Retain / Reformat negative time from Excel to Word Windows 7 64bit Retain / Reformat negative time from Excel to Word Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 19,525
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 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
Retain / Reformat negative time from Excel to Word How does Excel put values on negative degree(s)? JUSTIN CMM Excel 1 01-14-2016 12:41 AM
Retain / Reformat negative time from Excel to Word 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 05:35 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2019, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2019 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft