| 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? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Formatt date from text
Data Text to Columns Next Next select Date: MDY
"Hoot" wrote: 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? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Formatt date from text
If you just want the display:
Format/Cells/Number/Custom: 00\/00\/00 If you want the entries to actually be XL dates, see http://cpearson.com/excel/DateTimeEntry.htm In article , Hoot wrote: 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? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Formatt date from text
Thanks-
That's exactly what I was loooking for! "JE McGimpsey" wrote: If you just want the display: Format/Cells/Number/Custom: 00\/00\/00 If you want the entries to actually be XL dates, see http://cpearson.com/excel/DateTimeEntry.htm In article , Hoot wrote: 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? |
| Reply |
| 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) | |||
Linear Mode
