I have a column in a Numbers document that currently contains a number and that number is different in different columns. I want to add the words "Pack Qty" before each number in the column. How do I do that? I'm using Numbers '09 on a brand new Macbook Pro. Thanks!
MacBook, Mac OS X (10.7.1)
In an adjacent column add the formula:
="Pack Qty: "&<CELL>
where <CELL> is the cell in the same row where the quantity is,
Like:
E2="Pack Qty: "&D2
select, and hold, the little circle at the bottom right corner of the selction, then drag down
In an adjacent column add the formula:
="Pack Qty: "&<CELL>
where <CELL> is the cell in the same row where the quantity is,
Like:
E2="Pack Qty: "&D2
select, and hold, the little circle at the bottom right corner of the selction, then drag down
Thanks, Wayne. Extremely helpful and solved my issue!
Another option would be to create a custom format that includes the words and a format for the number.
One advantage to using a custom format as opposed to building a string is that the value in the cell remains a number, which can be more easily used in further calculations.
If you have other calculations that use the number of items in each pack, the custom format, if the Pack Qty is a final value, it's a six-pack of one, a half-dozen of the other choice of which method to use.
Regards,
Barry
I have a column in a Numbers document that currently only contains a number--the numbers are different in different columns. Before each number I want to add the words "Pack Qty." How would I do this?
