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.

Allison

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

Mike

"Alison" wrote:

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.

I need to turn these numbers:

6926
42410
4139

into:

692.6
424.10
413.9


"Mike H" wrote:

Allison

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

Mike

"Alison" wrote:

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.

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.
--
Thanks,
Shane Devenshire


"Alison" wrote:

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.

On Mon, 27 Oct 2008 12:18:05 -0700, Alison
wrote:

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

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" wrote:

On Mon, 27 Oct 2008 12:18:05 -0700, Alison
wrote:

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

On Mon, 27 Oct 2008 16:32:01 -0700, Alison
wrote:

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