ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Column Precision Settings (https://www.excelbanter.com/excel-programming/291718-column-precision-settings.html)

Ussiddiqui[_16_]

Column Precision Settings
 
Hi, can any one tell me that how to set the column precisio
settings....

--
Message posted from http://www.ExcelForum.com


Tom Ogilvy

Column Precision Settings
 
I don't believe there are any column precision settings. If you want to set
the number of decimal places displayed, select the column, then do
Format=Cells, choose the number tab, then number, then specify the number
of decimals to display.

If you want the stored number to match what is displayed, go to
tools=Options, Calculate tab and select precision as displayed - however
this is an application level setting and not applied to a single column.

--
Regards,
Tom Ogilvy

"Ussiddiqui " wrote in message
...
Hi, can any one tell me that how to set the column precision
settings.....


---
Message posted from http://www.ExcelForum.com/





All times are GMT +1. The time now is 12:10 PM.

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