Can you help please

[Eamon]

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

 

[Bob Phillips]

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]

Bob,

When I enter =D16+E16 in cell F16 and press enter a popup is coming up (If
that is the right term) which says
Microsoft Excel
(White X on Red background)
Must be whole number
Retry Cancel

Eamon

 

[Eamon]

Bob,

Got it, Validation - Allow Decimal - Minimum 0.1

Thanks for your reply

Eamon

 

[Niek Otten]

Someone set Data validation on your cell.
To clear: Data|Validation|Clear all

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| Bob,
|
| When I enter =D16+E16 in cell F16 and press enter a popup is coming up (If
| that is the right term) which says
| Microsoft Excel
| (White X on Red background)
| Must be whole number
| Retry Cancel
|
| Eamon
| | > 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)
| >
| > | >> 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
| >>
| >>
| >
| >
|
|

 

[Eamon]

Thanks Niek