PIZ Posted February 3, 2005 Share 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? Link to comment Share on other sites More sharing options...
Matt in KC Posted February 3, 2005 Share 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. Link to comment Share on other sites More sharing options...
PIZ Posted February 3, 2005 Author Share Posted February 3, 2005 Thanks, bud. That did the trick. Link to comment Share on other sites More sharing options...
PIZ Posted February 3, 2005 Author Share 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? Link to comment Share on other sites More sharing options...
billsfanone Posted February 3, 2005 Share Posted February 3, 2005 =a1*1.03 a1 being the cell with the original #. Link to comment Share on other sites More sharing options...
billsfanone Posted February 3, 2005 Share Posted February 3, 2005 Just type that in... Link to comment Share on other sites More sharing options...
PIZ Posted February 3, 2005 Author Share 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. Link to comment Share on other sites More sharing options...
Recommended Posts