I think I'd treat the entries as text and use a formula like:

=--substitute(a1,".","")

=substitute() returns a string.
the first minus converts the string to a number (but opposite sign). The second
minus changes the number back to the original sign.



ck wrote:

Hi,
I saw some posts regarding the ignoring of decimal points and the solutions.
What happens if a particular cell requires manual input and the decimal
places varies?

E.g.
1.25
89.1204
105.22

Requi
125
891204
10522

Any solutions for this? Thanks

--

Dave Peterson