Thread: Changing dates
View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.misc
MICHALK MICHALK is offline
external usenet poster
 
Posts: 4
Default 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!!