Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Column Precision Settings

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

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

  #2   Report Post  
Posted to microsoft.public.excel.programming
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/



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Save new column width settings in pivot table Dan Excel Discussion (Misc queries) 5 July 15th 08 03:07 PM
Column/line graph settings Zb Kornecki Charts and Charting in Excel 3 June 27th 08 06:13 AM
Default Row Height & column width Settings for new workbooks robbroy Excel Discussion (Misc queries) 2 March 8th 07 03:27 PM
Precision displayed does not match precision in cell James Wilkerson Excel Discussion (Misc queries) 10 June 15th 05 02:40 PM
Columns Precision Settings Ussiddiqui[_15_] Excel Programming 3 February 18th 04 02:16 PM


All times are GMT +1. The time now is 07:49 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"