cancel
Showing results for 
Search instead for 
Did you mean: 

Adding $ and comma in number value for column

Ganesh123
Meteor

Adding $ and comma in number value for column

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

 

CurrentRequirement
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
5 REPLIES 5
Ganesh123
Meteor

Adding $ and comma in number value for column

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

 

CurrentRequirement
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
Quasar

Re: Adding $ and comma in number value for column

Hey @Ganesh123 use the formula tool like so: 

Deano478_0-1677768567253.png

 

This will be the output from said formula:

Deano478_1-1677768592390.png

 

jimmyjames001
5 - Atom

Re: Adding $ and comma in number value for column

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

Re: Adding $ and comma in number value for column

@jimmyjames001 can you share the numbers your working with?

jimmyjames001
5 - Atom

Re: Adding $ and comma in number value for column

This is the formula i used by doesnt put in comors
 

 

 

Deano478
Quasar

Re: Adding $ and comma in number value for column

@jimmyjames001 is that was you envisioned as an output?