Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Inserting . in a number
I need to insert a . in a group of numbers:
before 123456789123 after 1234.5678.9123 Any ideas. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. . |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. . |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Inserting . in a number
I was asking that myself :-)
Trevor Shuttleworth wrote: Frank ? "JC" wrote in message ... Frank, you are the man!! Thanks!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Inserting new lines with corresponding number | Excel Discussion (Misc queries) | |||
inserting new lines with number | Excel Discussion (Misc queries) | |||
inserting page number | Excel Discussion (Misc queries) | |||
Inserting Number | Excel Worksheet Functions | |||
inserting a space in a number | Excel Worksheet Functions |