Thread: Changing dates
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default 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