| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
date to text formatting
need to convert today's date (10/06/03) into the text format "100603"
i give up, how do ya do it? thanks in advance mark |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
date to text formatting
Something like this
=TEXT(A1,"mmddyy") -- Regards, Peo Sjoblom "Mark Kubicki" wrote in message ... need to convert today's date (10/06/03) into the text format "100603" i give up, how do ya do it? thanks in advance mark |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
date to text formatting
Mark,
Try this. Sub ChangeMe() ActiveSheet.Range("B1").Value = Format(ActiveSheet.Range("a1").Value, "mmddyy") End Sub "Mark Kubicki" wrote in message ... need to convert today's date (10/06/03) into the text format "100603" i give up, how do ya do it? thanks in advance mark |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
date to text formatting
Mark,
Watch the line wrap Neil "Neil" wrote in message ... Mark, Try this. Sub ChangeMe() ActiveSheet.Range("B1").Value = Format(ActiveSheet.Range("a1").Value, "mmddyy") End Sub "Mark Kubicki" wrote in message ... need to convert today's date (10/06/03) into the text format "100603" i give up, how do ya do it? thanks in advance mark |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Numeric date to text..formatting question | Excel Discussion (Misc queries) | |||
| Is it possible to get Excel to stop formatting text as a date? | Excel Discussion (Misc queries) | |||
| Date formatting from text | Excel Discussion (Misc queries) | |||
| Text & Date Formatting | Excel Worksheet Functions | |||
| Formatting text and date together | Excel Discussion (Misc queries) | |||
Linear Mode
