Skip to main content


Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Archived » BIRT » How to format number for thousand separator and round of to 2 decimal(I want to show number 1000.0123 to 1,000.12 and 2345 to 2,345)
How to format number for thousand separator and round of to 2 decimal [message #1810689] Fri, 16 August 2019 07:45
Krunal Umak is currently offline Krunal UmakFriend
Messages: 2
Registered: January 2019
Junior Member
Hi All,

I want to show number 1000.0123 to 1,000.01 and 2345 to 2,345
For whole number, i don't want decimal.
I have achieved it using number%1 == 0, but while the report is exported to excel, it gives warning 'The number in this cell is formatted as text or preceded with apostrophe'
Previous Topic:XLSX export - single sheet or multi sheet during runtime
Next Topic:Birt supoports JDK11
Goto Forum:
  


Current Time: Tue Mar 19 05:16:24 GMT 2024

Powered by FUDForum. Page generated in 0.01651 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software

Back to the top