different columns, different decimal places

K

kyle

how do i get so that one column has one decimal place and another column has
two decinmal places?
 
F

FSt1

hi
high light the first column. right click the column. click format cells.
click the number tab. select number from the list on left. on the right,
click the spin button to 1. ok out.
repeat for the second column except click the spin button to 2. i think
default is 2.

Regards
FSt1
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access stripping decimal places in query 1
More than two decimal places 1
Determing Len of Numbers with Whole Numbers involved 4
Excel 2007 adding a column of negative and positive number 2
Setting decimal place for each row in a column 1
Convert 10 Decimal Places to 2 3
office 2003 Excel - SUM 3
how do i show 3 significant figures 1

Top