View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default 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/