No. Conditional formatting just changes the way that a cell's value is shown.
It can't actually change the value.
You'd have to write some code to change the cell's value since the YYYMMDD
entry in a cell isn't recognised as a date (at least not in Excel XP)


"M H" wrote:

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 ***