How to insert decimal in 5 digit #s but not 3 digit #s

[NUD]

I've done this before but can't recall now. I'm sure it's a simple solution. I'd appreciate any tips on the attached file. Thank you.

[popipipo]

=IF(LEN(A2)>=5,A2/100,IF(LEN(A2)=4,A2/10,A2))

Try this formula

[LARS GULYAS]

Is this simple solution answer to your question?

All numbers greater than 5 digits are divided by 100 using this formula
=IF(A2>9999,A2/100,A2)

/LGS