Format numbers with VBA Macro

[blelli]

Dears,

I have a spreadsheet where I would like to write a frequency in the cell A1, and the system will insert this value, formated, in the cell A2.
No matter the format I write, the system will always respect the following format "1XX.XX"

Example:
If I write 118.95, the system will write 118.95
If I write 18.95, the system will write 118.95
If I write 1895, the system will write 118.95
If I write 1189, the system will write 118.90

How can I do it?

Thanks a lot

 

[blelli]

Yes, the same here!

 

[Rick Rothstein]

I have a spreadsheet where I would like to write a frequency in the cell A1, and the system will insert this value, formated, in the cell A2.
No matter the format I write, the system will always respect the following format "1XX.XX"

Example:
If I write 118.95, the system will write 118.95
If I write 18.95, the system will write 118.95
If I write 1895, the system will write 118.95
If I write 1189, the system will write 118.90

Would you ever write 189 and, if you did, would the answer be 189.00 or 118.90 and why?