If the cell contains a number, it stores the same whether you type in 16 or
16. or 16.0 or 16.000000

If you want to distinguish what you've typed in, it will have to be text,
not a number.
--
David Biddulph

"jheath.bc" wrote in message
...
I'm wondering if there is a way to create a logical test to find out if a
decimal point was typed in a cell.

"16" would be false.
"16." would be true.

=if(a1 contains a decimal,a1,else use other formula)