Can I enter a date without using the / or hyphen?

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: mscpa (mscpa_at_discussions.microsoft.com)
Date: 12/12/04 

Date: Sun, 12 Dec 2004 10:13:02 -0800

I am trying to format a cell so I can type in the date without the slash or
dash. If I enter the date without these, it changes my date to some strange
number. What is going on? Why is this so hard to figure out?

Relevant Pages

  • Re: custom cell formating
    ... Type 12qwe in any cell in Columns A:E and will return 12Q--WE in Upper Case as ... Gary's Student ... spreadsheet with this format (number, number, letter, dash, dash, letter, ... Can anyone help me create this type of format? ...
    (microsoft.public.excel.worksheet.functions)
  • Re: custom cell formating
    ... Private Sub Worksheet_Change ... Type 12qwe in any cell in Columns A:E and will return 12Q--WE in Upper Case as ... spreadsheet with this format (number, number, letter, dash, dash, letter, ... Can anyone help me create this type of format? ...
    (microsoft.public.excel.worksheet.functions)
  • Re: custom cell formating
    ... Enter 74dqt and cell will display 74D--QT ... Gary's Student ... spreadsheet with this format (number, number, letter, dash, dash, letter, ... Can anyone help me create this type of format? ...
    (microsoft.public.excel.worksheet.functions)
  • Re: custom cell formating
    ... Enter 74dqt and cell will display 74D--QT ... Gary's Student ... spreadsheet with this format (number, number, letter, dash, dash, letter, ... Can anyone help me create this type of format? ...
    (microsoft.public.excel.worksheet.functions)
  • Re: custom cell formating
    ... Type 12qwe in any cell in Columns A:E and will return 12Q--WE in Upper Case as ... Gary's Student ... spreadsheet with this format (number, number, letter, dash, dash, letter, ... Can anyone help me create this type of format? ...
    (microsoft.public.excel.worksheet.functions)