Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
How to convert the following amount into two decimal correct number format ?
suppose I have number as 153,050.00 (something like 1,53,050.00)
Regards,
mahamed
May be this:
SET ThousandSep=',';
SET DecimalSep='.';
SET MoneyThousandSep='.';
//SET MoneyDecimalSep=',';
SET MoneyDecimalSep='.';
SET MoneyFormat='€ #.##0,00;€ -#.##0,00';
SET TimeFormat='h:mm:ss';
SET DateFormat='DD-MM-YYYY';
SET TimestampFormat='DD-MM-YYYY h:mm:ss[.fff]';
SET MonthNames='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec';
SET DayNames='Mo;Tu;We;Th;Fr;Sa;Su';
SET HidePrefix = '_';
Table:
LOAD *,
Num(GBPRateAmount, '#,##,##,##,##,##,###.##') as NewField;
LOAD * Inline [
GBPRateAmount
153.20
14.364
1123.645
246200.9687
];
Hi,
Use num(FieldName,'#,##,#00.00')
Kind Regards
May be try this:
=Num(Num#('153,050.00', '#,##0.00'), '#,##,##0.00')
or just this for a numeric field
=Num(FieldName, '#,##,##0.00')
=Num('153,050.00','#,##,##0.##', '.' , ',' )
hi,
Try this:
=num(your_Field, '#,##,##0.00')
or
Thanks,
AS
I don't understand your request.
In what sense is this a correct number format:
1,53,050.00
What is the rule behind using the thousand separator differently?
Stefan -
In India (and may be other parts of the world) we do use a different version of comma separators
For example:
10,00,00,000
Hi,
In Asia People use this kind of format.
Regards
That was an interesting read, thanks for the link!
Sunny, thank you for the link, I didn't know this indeed.
But I think we would need to give a full length format code then (e.g. assuming max 14 digits :
=Num(YourExpression, '#,##,##,##,##,##,##0','.',',')