Excel help please

Stattovic

Member
I have not used my Excel for some time and at my age my memory is not too good.

This is probably a simple item but searching google I cannot find an answer.

I need to put in Averages for a set of numbers, sometimes the average is 0.00 however when I put that it just shows a dash. I have seen items where I can put static numbers in that shows a small mark in the corner of the cell

Is there a way of showing the 0.00 this way in my spreadsheet please.

Many thanks
 
Last edited:
It is a display format issue. Right click on the cell and select "Foramt Cell". Select number, and set the decimal to 2.
 
Back
Top