I am using an input box to enter a number into a cell, but when I try to
enter a half number (for example .5), the cell rounds the number up to a
whole number. How do I format the cell to get the .5 to enter into the cell
and not have it round up to 1? I have tried formatting the cell as text but
still no luck.


Any suggestions?