View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bob Phillips Bob Phillips is offline
external usenet poster
 
Posts: 1,726
Default Can you help please

What do you get?

Is it just not showing the decimal places.


--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

"Eamon" wrote in message
...
Hi,

Can you help please
In D16 I have a number 1.40 format as number 2 decimal places.
In E16 I have a number 3 format as number 0 decimal places.
In F16 I enter =D16+E16 but I get "Must be whole number"
Why is it not calculating?

Thanks Eamon