I'm trying to determine the type of information in each column. I was using
the TYPE function but it doesn't differentiate between a Number and a Date.
The dates in my cells are either:

3/21/1999
3/21/1999 20:31:56 PM

....both of which Excel reads as a Number (type=1)

I want, basically:

if(type(A1)=1,"N",if(type(A1)=2,"C"...etc., so that my result in the cell is
either N, D, C, or L

Any ideas?

Merle