Posted to microsoft.public.excel.worksheet.functions

Hood

Posts: n/a

Date format default problem

If I type a serial 02/2668 into Excel it gets confused and thinks it is
February in the year 2668. This then confuses me. Is there a way of
straightening the matter.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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
MS Query Date Format	scos00	Excel Discussion (Misc queries)	0	October 21st 05 04:58 PM
Customized Date Format	Frustrated	Excel Worksheet Functions	5	October 7th 05 11:30 PM
NETWORKDAYS - Multiple Date Selection	Annabelle	Excel Discussion (Misc queries)	3	October 4th 05 07:04 PM
format date in excel	Nigel	Excel Discussion (Misc queries)	2	September 15th 05 09:52 PM
imported impromtu report date issue - fix by format or formula	Todd F.	Excel Discussion (Misc queries)	3	July 7th 05 09:57 PM

All times are GMT +1. The time now is 11:54 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us