how to place a decimal after 3rd digit

[Alison]

How do I place a decimal after the third digit of a number (e.g., ICD-9
code). Everything I have tried places decimals from the end of the number.
I need to place it third from the beginning of the number.

 

[Mike H]

Allison

I don't undertsand. Please post some before and after decimal insertion
numbers

Mike

 

[Alison]

I need to turn these numbers:

6926
42410
4139

into:

692.6
424.10
413.9

 

[ShaneDevenshire]

Hi,

If you really want to display ICD-9 as ICD.-9 then you will not be able to
do it unless the -9 is at the end of every 3 letter entry.

IF you want to change the items from ICD-9 to ICD.9 then use the Replace
command and replace - with ".".

IF you want to change the items from ICD-9 to ICD.-9 then use the Replace
command and replace - with ".-".

If this helps, please click the Yes button.

 

[Ron Rosenfeld]

How do I place a decimal after the third digit of a number (e.g., ICD-9
code). Everything I have tried places decimals from the end of the number.
I need to place it third from the beginning of the number.

You will need to enter the codes as TEXT. If you enter them as numbers, Excel
will drop the leading zeros and I know of no way to differentiate, for example,

012.8 from 128.0 if they are both entered as numbers without a decimal point.

Excel will store both as 128, but one is a type of TB, and the other is a
helminthiasis.

After entering the value as text, use:

=LEFT(A1,3)&"."&MID(A1,4,20)

20 is just some value longer than the longest code.
--ron

 

[Alison]

Thank you!! It worked. I did have to create the formula in a separate cell.
Once I got the numbers with correct decimals in place, I just copied and
pasted them into the original cells.

 

[Ron Rosenfeld]

Thank you!! It worked. I did have to create the formula in a separate cell.
Once I got the numbers with correct decimals in place, I just copied and
pasted them into the original cells.

Glad to help. Thanks for the feedback.
--ron