error - integer divided by a real number

[Pal]

Whenever I try to do a simple calculation such as 3/1.5 I get an error.
I have to input it as the same format - 3.0/1.5 then I get the value.

IS there a setting I can change to allow an integer to be divided by a real
number.
I am doing this right in the worksheet cell - no vba.

Thanks
Pal

 

[Michael R Middleton]

Pal -

Whenever I try to do a simple calculation such as 3/1.5 I get an error. I

have to input it as the same format - 3.0/1.5 then I get the value. IS there
a setting I can change to allow an integer to be divided by a real number. I
am doing this right in the worksheet cell - no vba. <

Have you tried preceding your numbers with an equal sign, e.g., "=3/1.5"
instead of "3/1.5" (without the quotes) ?

- Mike Middleton, www.usfca.edu/~middleton