A
Anonymous
I need excel to format a list of ip addresses. The problem I am
having is that I cannot figure out how to get the columns
formatted so any number I put in will be three digits. So a two
digit number such as "24" needs to become a three digit number
(024 in this example).
Here is a real example, if I enter:
158.2.151.13
Excel needs to make it:
158.002.151.013
Can this be done?
Thanks all!
having is that I cannot figure out how to get the columns
formatted so any number I put in will be three digits. So a two
digit number such as "24" needs to become a three digit number
(024 in this example).
Here is a real example, if I enter:
158.2.151.13
Excel needs to make it:
158.002.151.013
Can this be done?
Thanks all!