Excel formula

[Mikeymay]

Is there a formula that I can use in a spreadsheet that
can check whether the contents are a value or text.

Got a spreadsheet that needs values in a column, but do
occasionally get people using ' and " prefix to input
values therefore turning contents into text.


Cheers all

 

[Jack Schitt]

Yes
Check out
=ISNUMBER()
and
=ISTEXT()
in the help system

 

[Frank Kabel]

Hi
=ISTEXT(A1)
and
=ISNUMBER(A1)

 

[Mike A]

You should look at data validation.

Data > Validation...

You can specify that the cell(s) should contain whole numbers, decimals,
dates, etc. The users will get an error message (which you can also
customize in this dialog) if they enter anything other than what you allow.


Mike Argy
Custom Office solutions and
Windows/UNIX applications