Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Date format
I would like to enter a date without having to enter -'s or /'s and have it
display mm/dd/yy. I know how to make this work for phone numbers but can't seem to find the correct formatting for dates. Thank you. -- Though daily learning, I LOVE EXCEL! Jennifer |
#2
|
|||
|
|||
Visit Chip Pearson's site:
http://www.cpearson.com/excel/DateTimeEntry.htm And you'll find one way. Jennifer wrote: I would like to enter a date without having to enter -'s or /'s and have it display mm/dd/yy. I know how to make this work for phone numbers but can't seem to find the correct formatting for dates. Thank you. -- Though daily learning, I LOVE EXCEL! Jennifer -- Dave Peterson |
#3
|
|||
|
|||
when looking a Chip's page, note that you are changing
the value of the cell to a date. Dates are the number of days past a reference point such as Dec 31, 1899. Your formatting of a phone number did not change the value of phone number and was just formatting. I would suggest that you use text values for phone numbers, they work out much better that way (in my opinion), regardless of whether you left or right justify them. --- HTH, David McRitchie, Microsoft MVP - Excel "Dave Peterson" wrote in ... Visit Chip Pearson's site: http://www.cpearson.com/excel/DateTimeEntry.htm And you'll find one way. Jennifer wrote: I would like to enter a date without having to enter -'s or /'s and have it display mm/dd/yy. I know how to make this work for phone numbers but can't seem to find the correct formatting for dates. Thank you. -- Though daily learning, I LOVE EXCEL! Jennifer -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel enters date as a text format | Excel Discussion (Misc queries) | |||
How to format a date to a different format | Excel Discussion (Misc queries) | |||
Date Format Question | Excel Discussion (Misc queries) | |||
USING THE DATE FORMAT IN EXCEL | Excel Discussion (Misc queries) | |||
Problem with Date format from VBA code | Excel Discussion (Misc queries) |