Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Is there a way (by formatting or functions) to type a date into a cell with
no slashes and then it will be formatted with slashes? For example...If I want to type into a cell the date for Sept 10th 2006 and i type 091006 is there a way for it to format in the cell with the slashes. If I format the cell with a date format (and slashes) and I type into the cell 091006, I get back 02/28/49. Is there a feature available to be able to type the literal date into the cell without the slashes and receive that date in the cell with slashes? I understand the 1900 date formatting but I wasn't sure if there is a work around. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
Mail Merging Dates from Excel - Word Simple Problem! | Excel Discussion (Misc queries) | |||
add/subtract dates problem in Excel..... | Excel Discussion (Misc queries) | |||
TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | New Users to Excel | |||
Excel Range Value issue (Excel 97 Vs Excel 2003) | Excel Discussion (Misc queries) |