| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
When do I use quotation marks in an Excel formula?
Use quotes when directly referencing a text value. If you are referencing a
cell (A2), you would use quotes only if using the INDIRECT() function. Numeric values would not need quotes unless they are stored as text. "Deb" wrote: What are the guidelines as to when you do and do not use quotation marks in the criteria section of a function. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do i add quotation marks to every item in a column in excel | Excel Discussion (Misc queries) | |||
| Literal quotation marks retained from a formula | Excel Discussion (Misc queries) | |||
| How to stop Excel from inserting quotation marks into TXT files | Excel Discussion (Misc queries) | |||
| Use quotation marks in a formula to display a qty in feet and inc. | Excel Worksheet Functions | |||
| Excel Quotation Marks! | Excel Discussion (Misc queries) | |||
Hybrid Mode
