Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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
|
|||
|
|||
![]()
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
|
|||
|
|||
![]()
=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
|
|||
|
|||
![]()
=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
|
|||
|
|||
![]() "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
|
|||
|
|||
![]() "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
|
|||
|
|||
![]() "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 | |
|
|
![]() |
||||
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) |