Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
different columns, different decimal places
how do i get so that one column has one decimal place and another column has
two decinmal places? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
different columns, different decimal places
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 "kyle" wrote: how do i get so that one column has one decimal place and another column has two decinmal places? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Decimal places | Excel Worksheet Functions | |||
decimal places | Excel Discussion (Misc queries) | |||
Split number with decimal places into 2 columns | New Users to Excel | |||
Subtracting two 2-decimal place numbers gives result 13-decimal places? | Excel Worksheet Functions | |||
FIXED 2 DECIMAL PLACES, MUST ENTER ALL ZEROES AFTER DECIMAL POINT. | Excel Discussion (Misc queries) |