| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to format Date for 6 digit entry without entering /
Can someone tell me how to write a custom format code for Date Formatting.
I've seen this several years back and I don't remember the code which is similar to mm/dd/yy and the / does not have to be entered each time on the keyboard. My daughter wants to enter 081507 and the cell formatting is to display 08/15/07 Thanks Matt -- Please take a look at www.openoursite.com Click on: "Keywords" and then Click on "Matt's Story" and if you are a man, you should be very happy that you read my story. God Bless for everyones help. Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...tions/200708/1 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Date format shows on formula bar, 5 digit numbers show in row | Excel Discussion (Misc queries) | |||
| Automatically entering time and date to an entry | Excel Discussion (Misc queries) | |||
| How do i change the format of a 2 digit date | Setting up and Configuration of Excel | |||
| How do i format a 5 to 6 digit number into the correct date? | Excel Worksheet Functions | |||
| entering a 16 digit number - last value changes to 0 | Excel Discussion (Misc queries) | |||
Threaded Mode
