If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Importing and storing a different date format | Jim T | General Discussion | 1 | November 2nd, 2004 01:45 PM |
i cant change the format of the date when referencing another cell | Brian | Worksheet Functions | 3 | September 29th, 2004 05:02 AM |
Date format incorrect mail merge | Emily | Mailmerge | 1 | September 9th, 2004 10:22 AM |
Date Format | Date Formating Problem | Database Design | 3 | August 16th, 2004 06:41 PM |
If statement | Doug | Worksheet Functions | 9 | June 28th, 2004 06:13 AM |