Inserting . in a number
 

I need to insert a . in a group of numbers:
before 123456789123
after 1234.5678.9123

Any ideas.

Inserting . in a number
 

Hi
one way (if A1 stores this number):
=LEFT(TEXT(A1),4) & "." & MID(TEXT(A1),5,4) & "." & RIGHT(TEXT(A1),4)

--
Regards
Frank Kabel
Frankfurt, Germany

JC wrote:
I need to insert a . in a group of numbers:
before 123456789123
after 1234.5678.9123

Any ideas.

Inserting . in a number
 

JC

add a column and put this formula in the top cell:

=LEFT(A2,4)&"."&MID(A2,5,4)&"."&RIGHT(A2,4)

This assumes your data is in column A and starts in cell A2. Drag the
formula down. Select the new column of data. Copy it and then Paste
Special | Values back over itself. You can then copy the data over the
original if you wish.

Regards

Trevor


"JC" wrote in message
...
I need to insert a . in a group of numbers:
before 123456789123
after 1234.5678.9123

Any ideas.

Inserting . in a number
 

Frank, you are the man!! Thanks!!
-----Original Message-----
JC

add a column and put this formula in the top cell:

=LEFT(A2,4)&"."&MID(A2,5,4)&"."&RIGHT(A2,4)

This assumes your data is in column A and starts in cell
A2. Drag the
formula down. Select the new column of data. Copy it
and then Paste
Special | Values back over itself. You can then copy
the data over the
original if you wish.

Regards

Trevor


"JC" wrote in
message
...
I need to insert a . in a group of numbers:
before 123456789123
after 1234.5678.9123

Any ideas.


.

Inserting . in a number
 

Frank ?

"JC" wrote in message
...
Frank, you are the man!! Thanks!!
-----Original Message-----
JC

add a column and put this formula in the top cell:

=LEFT(A2,4)&"."&MID(A2,5,4)&"."&RIGHT(A2,4)

This assumes your data is in column A and starts in cell
A2. Drag the
formula down. Select the new column of data. Copy it
and then Paste
Special | Values back over itself. You can then copy
the data over the
original if you wish.

Regards

Trevor


"JC" wrote in
message
...
I need to insert a . in a group of numbers:
before 123456789123
after 1234.5678.9123

Any ideas.


.

Inserting . in a number
 

I was asking that myself :-)


Trevor Shuttleworth wrote:
Frank ?

"JC" wrote in message
...
Frank, you are the man!! Thanks!!