View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
jc jc is offline
external usenet poster
 
Posts: 18
Default 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.



.