Thread Tools Display Modes
  #1   Report Post  
Warrick Warrick is offline
Junior Member
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.
  #2   Report Post  
neiljohanson neiljohanson is offline
Junior Member
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

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 06:33 PM.

Copyright ©2000 - 2023, Jelsoft Enterprises Ltd.
Copyright 2004-2023 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.

About Us

"It's about Microsoft Word"