HELP?!

  • Thread starter Thread starter sconley
  • Start date Start date
S

sconley

I have a column of diagnosis codesstored as text without the ".", for
example, 03100, 1560, 95202, V08, etc.
I need another column of the same codes with the ".", 031.00, 156.0, 952.02,
V08.
Is there anyway that I can put the "." back in?
 
The "." is always after the third character. The lenght of the string can be
between 3 and 5 characters.
 
The "." is always after the third character.  The lenght of the string can be
between 3 and 5 characters.









- Show quoted text -

John's solution should work just fine.
 
Back
Top