Basic (perhaps) Question

J

JBCC

I work for a Chamber of Commerce, and am trying to create a spreadsheet that
will allow me to track prepaid expenses for some of our functions. For
example, a company might send us $100, and every event that they attend (some
are only a few dollars) will come off of the total.

What I envisioned was the ability to enter two different numbers (amount
used/remaining balance) within a single cell divided by a diagonal border. I
don't need it to calculate, but I will need the ability to sort the data by
company name as more checks come in to make the names easy to find.

Is it possible to enter two different values in the same cell and align them
differently?

Any other ideas?
 
D

Dave Peterson

Don't do it!

You've got 256 columns of cells. You'll make your life a lot easier if you put
each piece of data into a separate cell.

And if you can keep each "record" of data in a single row, you'll find things
are easier, too.
 
P

Paul Corrado

You definitely need to put the different amounts in different columns.

However, for presentation purposes (assuming that the data is in B1 and C1
for example) you can have it appear the way you desire for reporting
purposes.

Use the formula

=B1&" "&C1 (adjusting the number of spaces between the "" so the data
fills a cell.

Then just format that cell with a diagonal border.

When you issue the document you can just hide the columns.

Benefit is that with this data separated, you gain a tremendous amount of
functionality that you will most likely be able to use later on.
 
Top