| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Changing dates
How do you change a date to text and return a string such as mmddyy to
replace 01/01/10? In other words remove the slashes but keep the same numbers. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Changing dates
Use the text function, as in:
=text(a1,"mmddyy") Regards, Fred "MICHALK" wrote in message ... How do you change a date to text and return a string such as mmddyy to replace 01/01/10? In other words remove the slashes but keep the same numbers. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Changing dates
=text(a1,"mmddyy")
if A1 contained the date Or just format the cell using a custom format: mmddyy MICHALK wrote: How do you change a date to text and return a string such as mmddyy to replace 01/01/10? In other words remove the slashes but keep the same numbers. -- Dave Peterson |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Changing dates
=TEXT(cellref,"mmddyy")
Gord Dibben MS Excel MVP On Wed, 27 Jan 2010 13:42:01 -0800, MICHALK wrote: How do you change a date to text and return a string such as mmddyy to replace 01/01/10? In other words remove the slashes but keep the same numbers. |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Changing dates
"Dave Peterson" wrote: =text(a1,"mmddyy") if A1 contained the date Or just format the cell using a custom format: mmddyy MICHALK wrote: How do you change a date to text and return a string such as mmddyy to replace 01/01/10? In other words remove the slashes but keep the same numbers. -- Dave Peterson . THANKS SO MUCH!! |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Changing dates
"Fred Smith" wrote: Use the text function, as in: =text(a1,"mmddyy") Regards, Fred "MICHALK" wrote in message ... How do you change a date to text and return a string such as mmddyy to replace 01/01/10? In other words remove the slashes but keep the same numbers. . Thanks so much!! |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Changing dates
"Gord Dibben" wrote: =TEXT(cellref,"mmddyy") Gord Dibben MS Excel MVP On Wed, 27 Jan 2010 13:42:01 -0800, MICHALK wrote: How do you change a date to text and return a string such as mmddyy to replace 01/01/10? In other words remove the slashes but keep the same numbers. . THANKS SO MUCH!! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Dates changing | Excel Discussion (Misc queries) | |||
| Stop UK-style dates changing to US-style dates when mailmerging. | Excel Discussion (Misc queries) | |||
| changing dates. | Excel Worksheet Functions | |||
| Changing Dates | Excel Discussion (Misc queries) | |||
| Changing Dates | Excel Discussion (Misc queries) | |||
Linear Mode
