I would like a conditional format that would change the number of digits
after the decimal point depending on whether the number was in the 10's,
100's or 1000's

For example

1.02 would give 1.02
10.05 would give 10.05
100.13 would give 100.1
1004.13 would give 1004
10054 would give 10050

Can anyone help?