Inserting . in a number

  • Thread starter Thread starter JC
  • Start date Start date
J

JC

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

Any ideas.
 
Hi
one way (if A1 stores this number):
=LEFT(TEXT(A1),4) & "." & MID(TEXT(A1),5,4) & "." & RIGHT(TEXT(A1),4)
 
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
 
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





.
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

seperate numbers in a cell 1
cell format 2
Macro to insert Rows 4
Insert into database 6
VBA - retrieve data on last create named range from previous inserted named range 0
autoincrement number 0
insert a dash 5
insert rows 9

Back
Top