LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default Excel Dates w/ No Slashes

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
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 2003 FAILS, but Excel 2000 SUCCEEDS ??? Richard Excel Discussion (Misc queries) 2 May 13th 23 11:46 AM
Mail Merging Dates from Excel - Word Simple Problem! CFD Excel Discussion (Misc queries) 1 July 13th 06 01:08 AM
add/subtract dates problem in Excel..... Gary in Pennsyl Excel Discussion (Misc queries) 3 May 31st 06 08:58 PM
TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER MEGTOM New Users to Excel 5 October 27th 05 03:06 AM
Excel Range Value issue (Excel 97 Vs Excel 2003) Keeno Excel Discussion (Misc queries) 2 June 13th 05 02:01 PM


All times are GMT +1. The time now is 04:22 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"