Hi All:
I have a weekly file that spits out numbers stored as text. It breaks out the hundreds and thousands amounts in different cells.
In thousands cell:205 In hundreds cell:87 = 205,087
I currently use a concatenate formula to combine these two numbers and have to manually add an apostrophe and a zero before the 87. I've tried formatting the cell to a custom display of "000" that shows 3 digits, but the concatenate formula still only picks up the 87. Any thoughts on how I might go about this?
To add another variable, sometimes the hundred cell has all three numbers, aka 287, or might only have one number, aka 007.
Thanks!
I have a weekly file that spits out numbers stored as text. It breaks out the hundreds and thousands amounts in different cells.
In thousands cell:205 In hundreds cell:87 = 205,087
I currently use a concatenate formula to combine these two numbers and have to manually add an apostrophe and a zero before the 87. I've tried formatting the cell to a custom display of "000" that shows 3 digits, but the concatenate formula still only picks up the 87. Any thoughts on how I might go about this?
To add another variable, sometimes the hundred cell has all three numbers, aka 287, or might only have one number, aka 007.
Thanks!
Last edited:
