format number

irade92

Registered User.
Local time
Today, 05:15
Joined
Dec 26, 2010
Messages
229
Hello
How to format number 1,543.20 into 1543,20 with format function

Thanks
 
Try..
Code:
? Replace(Format(1523.20, "#######.00"), ".", ",")
1523,20
 
Try..
Code:
? Replace(Format(1523.20, "#######.00"), ".", ",")
1523,20

great Paul...thanks a lot and Happy New Year and many regards from Macedonia
 
If you want to visit Macedonia just let me know and I will arrange everything for you.
That is very kind of you ! Thank you. I am adding Macedonia to my list of places to go this year as we speak ! :)
 

Users who are viewing this thread

Back
Top Bottom