Excel: Legs, Eggs and Pigs Page 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17

Format Currency

6. Now, the net profit on a dozen eggs is $1.50 after shipping and handling. Hey! These are gourmet eggs, sold on the Internet. Under Net, type “1.50.”

 

You don’t need to type the dollar sign. We’re going to format the column. Select the Net column by clicking on the C column header. Now, click on currency (dollar sign) in the Number group. Excel formats the column so the dollars and cents line up.

AutoFill the $1.50 in cell C2 by selecting the cell and double clicking on the little black handle.

 

Home ->Number