Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formatt date from text
I would like to be able to enter a date numerically and have Excel formatt it
with the slashes, ie; fromatt 092207, to 09/22/07. I don't want to have to enter the slashes just the numeric value. How do I do this? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
formatt to Calculate difference in now() and date in cell, | Excel Discussion (Misc queries) | |||
How do I add a zero in front of a text formatt number? | Excel Worksheet Functions | |||
How do I add a zero in front of a text formatt number of 5000 reco | Excel Worksheet Functions | |||
How I convert date formatt of dd/mm/yy to mm/yy (not cell format) | Excel Discussion (Misc queries) | |||
How do you formatt text in Excel to be changed to UPPERCASE? | Excel Discussion (Misc queries) |