Retain "Thousands format" when concatenating cells
Hello,
I have two cells, "Amount Requested (local)" and "Local Currency Type" that I want to be concatenated in a single cell. I want the amount requested to retain the "," that is added by using "thousands" formatting
Here is my current formula, is there anything I can change it to so that it spits out "980,425 Euro" instead of "980425 Euro"? Applying thousands format to my new formula column doesn't work.
Answers
-
In your amount requested Please add an '
so when you type in the amount each time type it like this. '986,369
this ' will not show up in the cell but the number in the column will move to the left making it text and not a number.
Now you can use your formula
-
Hi Antonio,
Thanks for the idea, but it's not working unfortunately
In the first "Amount Requested (Local)" cell, I added this:
And this is the result
-
Yes but you have to put the , in the number as well
-
should look like this '980,425
-
Did this work
-
Oh I see. Yes it works if I remove the thousands formatting and manually do the formatting of the comma myself, but the data is brought in from datauploader/excel daily without the formatting
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!