Excel

Question

I have recently bought a new Mac book air and loaded excel. &nbsp;I cannot get excel to recognise decimals in any simple formula - what have I done wrong ?thanks&nbsp;

riny_van_eekelen · Answer

Heather1355&nbsp;When you say "cannot get excel to recognise decimals", perhaps your Mac expects to see a decimal comma in stead of a point or vice versa. Check and change the Language &amp; Region settings (Advanced) to what you want them to be.&nbsp;

heather1355 · Answer

Riny_van_Eekelen&nbsp;hi thank you - &nbsp;I did as you suggested now it’s just showing the formula in the answer box not the answer ?&nbsp;

riny_van_eekelen · Answer

Heather1355&nbsp;Did you perhaps press the "Show Formulas" button on the Formulas ribbon?

heather1355 · Answer

Riny_van_Eekelen&nbsp; hi again, yes I did! &nbsp;but when I clicked on it to not show formula the answer block went back to HashtagVALUE!!&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;

riny_van_eekelen · Answer

Heather1355&nbsp;Would need to see the file. Can you share it via Onedrive? Or send it to me via a direct message.

Forum Discussion

Excel

5 Replies

Resources