Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I show (.50) on in an Excel column-it keeps coming up (.5)
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I show (.50) on in an Excel column-it keeps coming up (.5)
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I show (.50) on in an Excel column-it keeps coming up (
"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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I show (.50) on in an Excel column-it keeps coming up (
Select the cell, goto menu FormatCells, and on the Number tab, select the
Number category, and set it there. -- __________________________________ HTH Bob "fnarkie" wrote in message ... "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 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I show (.50) on in an Excel column-it keeps coming up (.5)
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. -- Thanks, Shane Devenshire "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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Special paste column widths is not coming up in Excel 2007? | Excel Discussion (Misc queries) | |||
Excel 2007 user name not coming up | Excel Discussion (Misc queries) | |||
Excel Spreadsheet should be 5 pgs., coming out 10 pgs. | Excel Discussion (Misc queries) | |||
Summing a column, result coming up 0 | Excel Discussion (Misc queries) | |||
How to find which column or row the Min() value is coming from | Excel Discussion (Misc queries) |