Print 12/1/1 in cell (Excel changes it to date or another #

  • Thread starter Thread starter Say Goodnight, Gracie
  • Start date Start date
S

Say Goodnight, Gracie

While trying to formulate a magazine order list, Excel changes the number of
magazines needed (12/1/1) to a number other than that typed into the cell.
What I need is the number 12 (for English), 1 (for MP3) and 1 (for Finnish)
in this particular cell. How do I get it to print the actual numbers?
 
Use a database:

Customer Magazine Name Format Quantity
Fred Mag1 English 12
Fred Mag1 MP3 1
Fred Mag1 Finnish 1


etc.

Then you can pivot the data, get summary tables, filter, etc.

HTH,
Bernie
MS Excel MVP
 
Back
Top