Thread: Conditional Date Formatting
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
M H M H is offline
external usenet poster
  
Posts: 28
Default Conditional Date Formatting
Can I use conditional formatting to change the entry (e.g. in column F,
starting with F6) from "20050721" to a date format like 07/21/2005 with
the formula below?

=DATE(LEFT(F6,4),MID(F6,5,2),RIGHT(F6,2))

Please advice.

*** Sent via Developersdex http://www.developersdex.com ***
Reply With QuoteReply With Quote