LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 328
Default typing the date in a cell in excel and ###### comes up instead

I'm trying to put the date in to a cell in excel. It worked for the months of
July but when I try to put in August dates it just comes up with ######
instead of 08-Aug-07. Help anyone?
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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
Excel : while typing the Enter key, it does not move to the cell b Raphael Excel Discussion (Misc queries) 1 June 1st 07 03:19 PM
How do I enter a date typing 040906 and have it appear 04/09/06? I Stover New Users to Excel 3 September 12th 06 01:44 PM
can excel choose a name from a list when I am typing in a cell madisonville Excel Worksheet Functions 1 June 28th 06 03:28 AM
date entry without typing dashes Cyrus Excel Discussion (Misc queries) 2 February 28th 06 09:17 PM
typing mistaken for date format Excel Probs Excel Worksheet Functions 1 June 29th 05 07:49 AM


All times are GMT +1. The time now is 06:43 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"