Posted to microsoft.public.excel.misc

Mark

Posts: n/a

Unreadable date

I enter a date into a cell, such as 1/16/2006, and it appears as ########
when I hit enter or click on another cell. Why?

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
Need to Improve Code Copying/Pasting Between Workbooks	David	Excel Discussion (Misc queries)	1	January 6th 06 03:56 AM
Adding XY days to date in cells	satucha	Excel Discussion (Misc queries)	1	November 25th 05 08:02 AM
Another Date issue.	TimM	Excel Worksheet Functions	1	November 17th 05 01:58 AM
Date Math Problem	Dkline	Excel Worksheet Functions	4	March 4th 05 04:11 PM
Need help troubleshooting an array formula XLXP on Win2K	KR	Excel Worksheet Functions	1	December 13th 04 07:41 PM

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

About Us

"It's about Microsoft Excel"