PIZ Posted February 3, 2005 Posted February 3, 2005 I have a numbers in a column that are for example 0.30 How can I display that as .30 (dropping the first 0) and not change numbers that are for example 4.45?
Matt in KC Posted February 3, 2005 Posted February 3, 2005 Hightlight cells, go to format cells (CTRL+1 or right-click). On the numbers tab (1st tab) choose category of Custom and type .00 not 0.00.
PIZ Posted February 3, 2005 Author Posted February 3, 2005 Another question. I have a column of prices that I want to add 3% to. How would you go about doing that? I went to an empty cell right above the column. Then I typed in 1.03 Then I got on the cell and clicked COPY. Then I highlighted the column I wanted to add the 3% to and then went into EDIT and clicked PASTE SPECIAL. Then under OPERATION I clicked MULTIPLY and OK. Is that the best way to do it?
billsfanone Posted February 3, 2005 Posted February 3, 2005 =a1*1.03 a1 being the cell with the original #.
PIZ Posted February 3, 2005 Author Posted February 3, 2005 =a1*1.03 a1 being the cell with the original #. 227519[/snapback] I think I tried that, but I bet you any $ I forgot the = because I kept getting an error. Thanks.
Recommended Posts