ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   different columns, different decimal places (https://www.excelbanter.com/excel-discussion-misc-queries/245641-different-columns-different-decimal-places.html)

Kyle

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

FSt1

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?



All times are GMT +1. The time now is 08:24 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com