Format numbers

[blelli]

Dears,

How can I do the following "number formatting" using VBA:

If I write, 118.25; the system will write 118.25
If I write, 18.25; (without the first 1) the system will write 118.25
If I write, 11825; (without the decimal separator) the system will write 118.25
If I write, 1825; (without the first 1,and the decimal separator) the system will write 118.25
If I write, 182; (whitout the first 1, the decimal separator and the last number 5) the system will write 118.20

The numbers I'll use is a a range from 108.00 up to 137.00, varying from 05 to 05, like: 108.00, 108.05, 108.10.. 108.95, 109.00...

How can I do it?
Thanks a lot

 

[Joe4]

Duplicate: Format numbers with VBA Macro

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread. Per forum rules, posts of a duplicate nature will be locked or deleted (rule #12 here: Forum Rules).
If you do not receive a response, you can "bump" it by replying to it again, though we advise you to wait 24 hours before doing and not to bump a thread more than once a day.