Page 1 of 1

Format Cell as Percentage and DateTime

Posted: Thu Jun 15, 2017 9:23 am
by vdev
Hi guys,

1. How can i format a cell as a percentage?


2. If I set the style of a cell that doesnt have a value I get an access violation. Is there a way to "prepare" the cell for formatting while there is no value behind it?

Re: Format Cell as Percentage and DateTime

Posted: Mon Jun 19, 2017 4:27 pm
by larsa
Hello

1. Set the NumberFormat property to '0.00' if you want two decimals.

2. Make the cell a blank cell, like: XLS[0}.AsBlank[Col,Row] := True;