Posted to microsoft.public.excel.misc

Steve

external usenet poster

Posts: 1,814

date formats

I am using the date format of MM/DD/YYYY in a spreadsheet. I am trying to
update 12/31/2005 to 12/31/2006 and when I do so, the date comes back to me
as
01/01/1900, but the formula bar reads =12/31/2006.

How do I fix this???

Steve

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 custom formats	Jonathan	Excel Discussion (Misc queries)	2	September 22nd 06 08:28 PM
Help with converting date formats	k3639	Excel Worksheet Functions	7	July 27th 06 11:21 PM
pivot table not reading date formats	Todd	Excel Worksheet Functions	1	July 20th 06 07:01 PM
insert date	Larry	Excel Worksheet Functions	28	July 15th 06 02:41 AM
How to return a value between date ranges	Mary-Lou	Excel Worksheet Functions	7	May 26th 06 10:00 PM

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

About Us

"It's about Microsoft Excel"

Menu

About Us