I received this query by email:
Quote:I tried to put 1221 in a format like: 1 221.000
The lower comma used locally as decimal point so I can't use it. |
|
One of the LBB extensions is to format a number with 'thousands separators', but the only supported separator character is a comma - which as the OP says is used in some regions as the 'decimal point'. An easy way to achieve the desired result is firstly to format it with comma separators, and then change the commas to spaces:
Code:print format$(1221)
end
function format$(number)
format$ = using("#,###,###.###", number)
do
i = instr(format$, ",")
if i then mid$(format$, i, 1) = " "
loop until i = 0
end function
Richard.
Logged