Adding $ and comma in number value for column

[Ganesh123]

Can someone please help us in adding the $ and coma's to number value

Current	Requirement
45641433.57	$                         45,641,433.57
816.5516612	$                                       816.55
2311232594	$                   2,311,232,593.68
7687.55515	$                                    7,687.56
9381.352711	$                                    9,381.35
17333.62932	$                                 17,333.63
69.9777061	$                                          69.98

[Deano478]

Hey @Ganesh123 use the formula tool like so: 

This will be the output from said formula:

[jimmyjames001]

i cant seem to get a comor in using that formula only the £ sign?

[Deano478]

@jimmyjames001 can you share the numbers your working with?

[jimmyjames001]

This is the formula i used by doesnt put in comors

[Deano478]

@jimmyjames001 is that was you envisioned as an output?