Excel numeric format

Discussion forum for PivotCube VCL users. Common questions. Bug and problem reports

Moderator: Alex Zencovich

Excel numeric format

Postby Siegmar Gieseler » Mon Jun 26, 2006 3:03 pm

I am using EXCEL in Brazilian Portugues and the follwing mask for a Dimension:

##,###,###.##

A numeric value in EXCEl becomes

12,345,23

but it should be:

12.345,23

It seems to be a Bug.
Siegmar Gieseler
User
 
Posts: 9
Joined: Mon Jun 19, 2006 2:49 am

Re: Excel numeric format

Postby AlexZencovich » Mon Jun 26, 2006 4:10 pm

Siegmar Gieseler wrote:I am using EXCEL in Brazilian Portugues and the follwing mask for a Dimension:

##,###,###.##

A numeric value in EXCEl becomes

12,345,23

but it should be:

12.345,23

It seems to be a Bug.


You need to use #,###.00 instead. Only one comma required to specify you need a thousand separator
Best regards,

Alex Zencovich
-------------------------------------------------------------------------------------------------------------------------------------------
www.pivotcube.com - OLAP solution for Delphi, C++ Builder and ActiveX environment
AlexZencovich
Site Admin
 
Posts: 580
Joined: Sun Jun 18, 2006 10:09 am


Return to PivotCube VCL

Who is online

Users browsing this forum: No registered users and 5 guests

cron