Format Cell as Percentage and DateTime

[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?

[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;