LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 89
Default Cant get dd/mm date format in Excel 2003

I've imported an Excel 200 file into Excel 2003. The date column worked
perfectly as dd/mm on my machine in Excel 2000 but refuses to show that way
in 2003 on another machine. Both are XP, the original "Home edition", the
destination machine on "Professional".

I've gone through Format/cells/number/date/ routine, and
format/cells/number/custom.

I've gone to control panel and Regional Settings . None of these options are
making any difference. Even blank cells in the column will not accept the
date in the typed in format of dd/mm whereas it was never a problem in the
originating machine under Excel 2000.

Any ideas?

Thanks in advance.
 
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 2003 can you change the header date format? ldedmon Excel Discussion (Misc queries) 0 March 7th 07 06:11 PM
Where can I change the footer &[Date] format in Excel 2003? IVVE Setting up and Configuration of Excel 0 March 21st 06 03:21 PM
date format in Excel 2003 Chunt Excel Discussion (Misc queries) 1 September 15th 05 01:09 AM
Excel 2003 date format bug? ChrisCPS Excel Discussion (Misc queries) 2 July 7th 05 06:03 AM
How do I report a Date Format bug in Excel 2003 to Microsoft ? KymY Excel Discussion (Misc queries) 1 April 6th 05 12:45 PM


All times are GMT +1. The time now is 04:07 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"