I'm trying to do a spreadsheet where I have the number of accounts, the @ symbol and then the amount.
So it should look like:
15 @ $50,000
13 @ $75,000
The problem is I can never get all the characters to line up. I want the number, the @ and then final amount to line up with each other so when I print it they'll be even.
How do I do this in excel?How do you line up numbers and letters in different rows?
Format the cells to ';centre'; BEFORE you input the data.How do you line up numbers and letters in different rows?
Numbers should justify right, text left. Select the column, Format, Cells. Be careful of any supposedly number cells you might have added spaces to.
Put each of them in a column.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment