Dates in cells are no longer visable but are showing as ########

's Computer Specifications

My column of cells are formatted as date (03/04/08). First 16 lines in
column are showing correctly but now all I see when I imput the correct date
(different each time) is #######. Sheet is not locked.

's Computer Specifications

Widen the column

"joh" wrote:

> My column of cells are formatted as date (03/04/08). First 16 lines in
> column are showing correctly but now all I see when I imput the correct date
> (different each time) is #######. Sheet is not locked.

's Computer Specifications

Or use a smaller font.

Or make sure that the text isn't showing a 4 digit year.

joh wrote:
>
> My column of cells are formatted as date (03/04/08). First 16 lines in
> column are showing correctly but now all I see when I imput the correct date
> (different each time) is #######. Sheet is not locked.

--

Dave Peterson

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
how do I look for cells showing dates less than a certain date?	Annie and Naseem @ Ecojustice	Microsoft Excel Worksheet Functions	1	16th Apr 2009 01:15 AM
How to Sum-If when the cells to sum are Auto-filter visable cells?	=?Utf-8?B?RGVubmlz?=	Microsoft Excel Misc	3	24th Feb 2006 11:49 PM
Photos no longer visable in Access 2003	=?Utf-8?B?TUFUNFJvbg==?=	Microsoft Access	1	18th Dec 2005 10:03 PM
Visable Cells	=?Utf-8?B?anRveQ==?=	Microsoft Excel Misc	1	21st Jul 2005 02:32 AM
Outlook 2000 - date navigator (those mini month calendars in the corner) no longer showing active dates in bold	Outlook 2000 User	Microsoft Outlook	5	5th Mar 2004 03:27 PM