How do I show (.50) on in an Excel column-it keeps coming up (
hi
your cell is formatted to general.
so.
right click the cell(s) that you want formated to 2 decimals
from the popup, select format cells.
from the format dialog, select the number tab.
from the catagory list, select number
to the right will be a spin button where you can select the number of
decimal places you want. default is 2.
when done, click the ok button.
regards
FSt1
"fnarkie" wrote:
"Pete_UK" wrote:
Format the cells as Number with 2 decimal places.
Hope this helps.
Pete
On Oct 19, 7:34 pm, fnarkie wrote:
I am trying to add figures on Excel-instead of 1/2 I am trying to use .50-but
it keeps coming up .5-How can I get the 0 in after the 5
Can u explain the solution more clearly-sorry I'm new at this
|