LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
WhytheQ
 
Posts: n/a
Default Break links automatically changes graph's date format

(this is Excel 2003)

We have a graph in BookA.
When I open BookA the format of the dates on the X axis are
01-Jan-2006.
When I use EditLinksBreak Link to BookB, the dates on the graph
revert to a general integer: 38718

Any one ever encountered this befo any ideas how to preserve the
format?

Any help greatly appreciated,
Jason

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel date format trouble michaelberrier Excel Discussion (Misc queries) 2 April 21st 06 05:21 AM
MS Query Date Format scos00 Excel Discussion (Misc queries) 0 October 21st 05 04:58 PM
Change general format to US date format woodlot4 Excel Discussion (Misc queries) 3 October 11th 05 12:29 AM
imported impromtu report date issue - fix by format or formula Todd F. Excel Discussion (Misc queries) 3 July 7th 05 09:57 PM
prevent 4/5 in a cell automatically transfer to a date format kei Excel Discussion (Misc queries) 3 December 9th 04 11:52 AM


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

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"