Use Format | Conditional Formatting
Set Formula to =NOT(ISNUMBER(A1)) ---- change reference to suit need
And make font and/or pattern to colour (red?)

best wishes

--
Bernard Liengme
www.stfx.ca/people/bliengme
remove CAPS in email address


"RTP" wrote in message
...
Is there any way with a formula to make sure a cell is numeric and to post
an
error message if it is NOT numeric???