removal of . in a string of numbers

[conjohn562]

Is there a way to remove "." in a string of numbers? is it a formula? For example, number looks like this 9999.00.0000 and I need to remove all the .'s How is the best way of doing this?

[MrShorty]

The Find and Replace command can do this https://support.office.com/en-us/art...f-fdb42f892e90
or the SUBSTITUTE() function: https://support.office.com/en-us/art...0-1e58df3bc332

[Special-K]

SUBSTITUTE(A1,".","")
or
SUBSTITUTE(A1,".","")+0
depending if you want a text or numeric result.

Bear in mind if the result exceeds ten digits using the second formula it will result in an exponential value, e.g. 12346E+10