Page 1 of 1

Decimal format excel

Posted: Fri Apr 13, 2012 5:55 am
by Mixxxa
Hello, guys.
When I import data to excel I can't properly choose format for decimal data.
Cells containing the data all the time seem to be in text format despite all my efforts.
{0:C2} format does not work either. Is there some other way?
Thank you very much

Decimal format excel

Posted: Fri Apr 13, 2012 8:40 am
by HighAley
Hello.
Mixxxa wrote:Hello, guys.
When I import data to excel I can't properly choose format for decimal data.
Cells containing the data all the time seem to be in text format despite all my efforts.
{0:C2} format does not work either. Is there some other way?
You should set the Text Format property of the Text box. If it set to General then the format in the Excel file will be string.

Thank you.