date or text

[Guest]

Hi

Is there a way of working out if the information in a list is text or a date.

In a long list I need to determine the above.

It needs an IF statement so if it is a date perform a calculation otherwise do not.

can anyone help. Any suggestions are appreciated

kind regards

Rexmann

 

[JulieD]

Hi Rexmann

there is an ISTEXT function which returns true if the entry is text and
false if its not so you could construct an IF statement along the lines of:

=IF(ISTEXT(A1),"text","not text")

Cheers
JulieD

 

[Guest]

Hi JulieD

just tried it out and it works great.

Job done

thanks Rexmann

 

[Freemini]

another way which differentiates between numbers, text and dates

=IF(LEFT(CELL("format",C6))="D","Date","")

hth

Mik

 

[JulieD]

glad its solved

cheers
JulieD

Hi JulieD

just tried it out and it works great.

Job done

thanks Rexmann

 

[Dave Peterson]

You might want to add a check to see if there's a date in that cell--not just
check the format:

=IF(AND(ISNUMBER(C6),LEFT(CELL("format",C6))="D"),"Date","")