| 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 | |||
Linear Mode
