Thanks in advance for any help you all provide!!

I am trying to come up with a function that will identify if a cell has
a decimal in it. My staff will be entering budgetary amounts into a
spreadsheet and I want the amounts to be in whole dollars. I want to
be able to use this function with conditional formatting to identify
the decimal (error) when they enter it.

does that make sense?


--
Celt
------------------------------------------------------------------------
Celt's Profile: http://www.excelforum.com/member.php...o&userid=19413
View this thread: http://www.excelforum.com/showthread...hreadid=513350