You could remove decimal places like:

=SUBSTITUTE(A1, ".", "")

However, there is a reason the dotted notation exists. Each number
represents an 8 bit number (0-255)
So, for example, the IP address 121.12.123.123 without dots would be the
same as 12.112.123.123


--
Rob van Gelder - http://www.vangelder.co.nz/excel


"riffmastr" wrote in message
...
I'm trying to remove decimal places from IP addresses (example
24.12.118.76)
in excel so I can treat them as regular numbers. I really just want to use
the beginning part (24). Does anybody know how to convert this to a
regular
number?