To display a dash (-) as the first character in a cell in Microsoft Excel (so it isn’t interpreted as a mathematical symbol), prefix the dash with an apostrophe, like so:
'- This value begins with a dash.I’ve been programming in VBA for Excel and other products since VBA first came out, but I’m not an expert at using them as they were intended; I’d rather create a function to do some manipulation than create a formula, though I know a formula is often more efficient.
What if you wanted to subtract “fart” from “butt”? You couldn’t do butt-fart anymore, since it’s now a string!
Jody, another way to do it is to format the cell as Text. Use Format * Cell. In the Number tab, choose Text from the Category list.
I knew that, gosh darn it.
Thanks.
Excel is fun.
unfortunately, i’ll never use it again.