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