Skip to main content
Announcements
Customer Spotlight: Discover what’s possible with embedded analytics Oct. 16 at 10:00 AM ET: REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Format numbers with all dots

Good morning,

I have to change the number format from this format eg 6.200.500 in 6.200,500

I have to replace the first dot on the right in comma, how can I do?

Thanks

1 Reply
vishsaggi
Champion III
Champion III

May be try this?

= Subfield(Numb, '.', 1)&'.'&Subfield(Numb,'.',2)&','&Subfield(Numb, '.',3)