F
fnarkie
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
it keeps coming up .5-How can I get the 0 in after the 5
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
P
Pete_UK
Format the cells as Number with 2 decimal places.
Hope this helps.
Pete
Hope this helps.
Pete
F
fnarkie
Pete_UK said:Format the cells as Number with 2 decimal places.
Hope this helps.
Pete
Can u explain the solution more clearly-sorry I'm new at this
F
FSt1
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
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
B
Bob Phillips
Select the cell, goto menu Format>Cells, and on the Number tab, select the
Number category, and set it there.
Number category, and set it there.
S
ShaneDevenshire
Actually,
if your cell really displays .5 and not 0.5 then you are not formatted to
general, that would be a custom format of .0 or .# or...
If you really want .50, not 0.50, again not a standard format, choose
Format, Cells, Number tab, Custom and enter .00 or .00# on the Type line.
I doubt this helps, but that's the way it really is.
if your cell really displays .5 and not 0.5 then you are not formatted to
general, that would be a custom format of .0 or .# or...
If you really want .50, not 0.50, again not a standard format, choose
Format, Cells, Number tab, Custom and enter .00 or .00# on the Type line.
I doubt this helps, but that's the way it really is.