| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Print 12/1/1 in cell (Excel changes it to date or another #
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? |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Print 12/1/1 in cell (Excel changes it to date or another #
try putting a ' infront of the numbers
"Say Goodnight, Gracie" wrote: 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? |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Print 12/1/1 in cell (Excel changes it to date or another #
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 "Say Goodnight, Gracie" wrote in message ... 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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Print Modified date stamp on excel sheet | Excel Discussion (Misc queries) | |||
| How can i add a print-and save-date field in Excel as in Word? | Excel Worksheet Functions | |||
| How can i add a print-and save-date field in Excel as in Word? | Excel Discussion (Misc queries) | |||
| Excel cell looks good in print preview but doesn't print??? | Excel Discussion (Misc queries) | |||
| Print Footer with Last Print Date field name | Excel Discussion (Misc queries) | |||
Hybrid Mode
