error - integer divided by a real number

  • Thread starter Thread starter Pal
  • Start date Start date
P

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
 
Pal -
Whenever I try to do a simple calculation such as 3/1.5 I get an error. I
Click to expand...
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
 
Back
Top