how to place a decimal after 3rd digit

  • Thread starter Thread starter Alison
  • Start date Start date
A

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.
 
Allison

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

Mike
 
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.
 
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.
Click to expand...

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.
 
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.
Click to expand...

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