....something like...

=IF(AND(ISNUMBER(A1),LEFT(CELL("format",A1),1)="d" ),"it's a date","not a date")



sparx wrote:

How do I write a formula that can tell if a cell is a date or a value so
it can display the correct info - I hava 3 columns - one is text - one
is currency - one is date.
I have a cell that can pick between all 3 ( say A1 or B1 or C1 ) but it
shows the currency and date as a date style cell if its looking at the
currency value???

--
sparx
------------------------------------------------------------------------
sparx's Profile: http://www.excelforum.com/member.php...o&userid=16787
View this thread: http://www.excelforum.com/showthread...hreadid=488775

--

Dave Peterson