A Microsoft Word forum. Microsoft Office Word Forum - WordBanter

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » Microsoft Office Word Forum - WordBanter forum » Microsoft Word Newsgroups » Mailmerge
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

Retain / Reformat negative time from Excel to Word

Thread Tools Display Modes
Old May 12th 18, 01:32 AM
Warrick Warrick is offline
Junior Member
First recorded activity by WordBanter: May 2018
Posts: 1
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.
Old May 30th 19, 10:46 AM
neiljohanson neiljohanson is offline
Junior Member
First recorded activity by WordBanter: May 2019
Posts: 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.

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Why Word 2007 mail merge does not retain number format from Excel sretep Mailmerge 1 June 6th 09 02:55 PM
How do I get Word to retain Excel formatting, eg zip code, ssn? soxn4n04 Mailmerge 1 December 1st 05 04:52 AM
Insert Excel cells in MS-Word and retain Excel Functionalitity? David in NM Tables 1 October 20th 05 09:52 PM
How to copy linked Excel and Word files and retain links Phil Microsoft Word Help 1 May 8th 05 07:51 PM
How do I retain formatting from an Excel Data File to a Word Merg. Pookas Microsoft Word Help 5 March 14th 05 10:32 PM

All times are GMT +1. The time now is 12:05 PM.

Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
Copyright 2004-2021 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.