Boolean.toString

[lallo]

Hi,

Newbie question: When I write "true" to a cell Excel automatic turns i
into "TRUE". How can I get rid of this. I'm handling my excel files a
raw data and the cell values must be String, not Boolean.

Thanks

 

[Andy B]

Hi

Try putting an apostrophe first 'true
Excel will treat this as a text input

Andy.

 

[lallo]

Thanks Andy B, that works