Board index » delphi » Numeric Formatting an entire column

Numeric Formatting an entire column


2007-01-23 05:25:53 AM
delphi168
Hi all -
In Delphi How do I programatically select an entire column and set the
column to a numeric format that includes decimal separator and a
specified number of decimals?
Thanks,
Matthew
 
 

Re:Numeric Formatting an entire column

xls.ActiveSheet.Columns[yourColumn].NumberFormat := '0.00';
"matthew" <XXXX@XXXXX.COM>writes
Quote
Hi all -

In Delphi How do I programatically select an entire column and set the
column to a numeric format that includes decimal separator and a
specified number of decimals?

Thanks,

Matthew