Decimal format excel

Mixxxa · Post by **Mixxxa** » Fri Apr 13, 2012 5:55 am

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

Post by **HighAley** » Fri Apr 13, 2012 8:40 am

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.