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?

Bumper

Can you give a little more detail what the inputbox is, are you displaying
this through code and is it Excel's inputbox (method) or VBA's Inputbox
function?

Just need a little more detail

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
DTHIS
www.nickhodge.co.uk


"bumper338" wrote in message
...
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?

Sub input_test()
strInput = InputBox("Number Please?", "Wee!")
Range("A1") = strInput
End Sub

"bumper338" wrote:

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?

I forgot to mention, works fine as is when entering .5, but the cell A1 was
set to General formatting.

HTH

"Wood Grafing" wrote:

Sub input_test()
strInput = InputBox("Number Please?", "Wee!")
Range("A1") = strInput
End Sub

"bumper338" wrote:

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?

That worked, thanks.

"Wood Grafing" wrote:

I forgot to mention, works fine as is when entering .5, but the cell A1 was
set to General formatting.

HTH

"Wood Grafing" wrote:

Sub input_test()
strInput = InputBox("Number Please?", "Wee!")
Range("A1") = strInput
End Sub

"bumper338" wrote:

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?