Irregular formation of numbers

  • Thread starter Thread starter Diamonelle
  • Start date Start date
D

Diamonelle

Hi,

I hope someone can help, I am trying to format numbers in a column.
the numbers are all 10 digits (ie. 0405613020) and from cell to cel
are all different.

What I am trying to do is for them to take on the format below:

0405.61.30.20

I have tried different things.. but nothing seems to work.. I have ove
250 cells that need to look like that, and it's very long and tedious..

Hope someone can help me..

Diamonelle :confused
 
Hi

You can put this formula in a helper column, copy it down as far a
needed and then copy-paste special - values back into the origina
column:

Assuming your first cell with the 10 digit number is inF10

=LEFT(F10,4)&"."&MID(F10,5,2)&"."&MID(F10,7,2)&"."&RIGHT(F10,2
 
Hi,

I hope someone can help, I am trying to format numbers in a column.
the numbers are all 10 digits (ie. 0405613020) and from cell to cell
are all different.

What I am trying to do is for them to take on the format below:

0405.61.30.20

I have tried different things.. but nothing seems to work.. I have over
250 cells that need to look like that, and it's very long and tedious..

Hope someone can help me..

Diamonelle :confused:
Click to expand...

Format/Cells/Number/Custom Type: 0000\.00\.00\.00

will do it.


--ron
 
Back
Top