Posted to microsoft.public.excel.worksheet.functions

Mel

external usenet poster

Posts: 74

Date Formating

One of our users has an excle worksheet with three date columns all fomatted
as date. Formattig being used is 2/22/07 for example. However for all three
columns when you type in the required date of say 2/22/07 and hit enter, it
defaults to 01/00/00. It defaults to 01/00/00 in each cell for these three
date columns. How can I fix this?

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
Date formating	Hawksby	Excel Discussion (Misc queries)	2	December 14th 06 06:33 PM
Date formating	chad	Excel Worksheet Functions	3	October 21st 06 03:31 PM
Can I use the date in conditiional formating?	gargoyle	Excel Worksheet Functions	5	August 6th 06 05:32 PM
Formating decimal and date	Rick	Excel Worksheet Functions	1	March 26th 05 05:10 AM
Conditional formating w/ Date	Steven Stadelhofer	Excel Worksheet Functions	1	February 3rd 05 05:29 PM

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

About Us

"It's about Microsoft Excel"

Menu

About Us