| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
spreadsheet
hey i need to know how to make a letter(checkmark) appear as a dollar amount
when going into a total |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
spreadsheet
What? That doesn't make much sense... If I understand you correctly, just
format the cell as currency or accounting, noting the dollar sign. "stacy" wrote: hey i need to know how to make a letter(checkmark) appear as a dollar amount when going into a total |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
spreadsheet
Stacy,
Array enter (enter using Ctrl-Shift-Enter) a formula like =SUM(EXACT(A1:A1000,B1)*AMOUNT) where B1 contains a checkmark (format it with the same font), and AMOUNT has been replace with the value of each checkmark.... HTH, Bernie MS Excel MVP "stacy" wrote in message ... hey i need to know how to make a letter(checkmark) appear as a dollar amount when going into a total |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I copy spreadsheet data as shown to another spreadsheet? | Excel Discussion (Misc queries) | |||
| convert ms works spreadsheet to excel spreadsheet on pda | Excel Discussion (Misc queries) | |||
| conversion of MS Works Spreadsheet to Excel 2002 Spreadsheet | Excel Discussion (Misc queries) | |||
| Is there a way to insert a formula, password or macro in an excel spreadsheet that will automatically delete the spreadsheet? | Excel Discussion (Misc queries) | |||
| How do I convert exel spreadsheet to works spreadsheet? | Excel Discussion (Misc queries) | |||
Linear Mode
