Thread: Extract Date (04/05/06) into Text (040506)
View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.programming
ward376 ward376 is offline
external usenet poster
  
Posts: 360
Default Extract Date (04/05/06) into Text (040506)

oops, double post

This formula will give you mmddyy as text as long as excel recognizes
it as a date regardless of format. Even if it's formatted as a number,
general etc.

Reply With QuoteReply With Quote