Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Linda - Xtremly Peeved
 
Posts: n/a
Default Excel date format merging to Word XP version

We have recently swapped over to Windows XP and I am now having a problem
with merging to Word. I need to insert a pre-determined date which is
entered in excel as a dd/mm/yy (ie 03/03/05) raw data set to dddd, dd mmm
yyyy (ie Thursday, 03 March 2005) format in Excel to keep this format in
Word. In our old version this would merge over automatically keeping the day
month etc typed out but now with XP this formatting is being lost (showing as
ie 03/03/05 12:00AM). The formatting refers to the actual text rather than
just the font style.

Also numbers are having .0 added to the end after the merge. (ie 75 in
excel (cell format etc set to numbers with 0 decimal) is being merged to Word
as 75.0)
Any suggestions???
 
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
how to convert wordperfect 5.0 floppy files to word pcoelho Microsoft Word Help 2 February 17th 05 06:55 PM
How do I create & merge specific data base & master documents? maggiev New Users 2 January 12th 05 11:30 PM
word xp crashes after macros are recorded kharris0405 Microsoft Word Help 3 January 11th 05 10:50 PM
WordPerfect - copying formatting Morgan Page Layout 1 January 10th 05 05:00 PM
How do I convert a cd in word perfect to microsoft word greylady Microsoft Word Help 1 November 23rd 04 07:03 PM


All times are GMT +1. The time now is 06:48 AM.

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

About Us

"It's about Microsoft Word"