View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
ShaneDevenshire ShaneDevenshire is offline
external usenet poster
 
Posts: 2,344
Default how to place a decimal after 3rd digit

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.