Alternative to apostrophe?

d2100 · Apr 11, 2002

Is there an alternative to using an apostrophe or single quote to designate a quantity or number as a label?

Tom Urtis · Apr 11, 2002

This will probably sound obvious, but would formatting the cell(s) as Text do what you want? If not, what are you trying to accomplish?

spg2112 · Apr 11, 2002

Sometimes formatiing cells to text doesn't work for for me. I know that sounds crazy, but it doesn't. I use this:

=TRIM(TEXT(A1,0))

Steve

Yogi Anand · Apr 11, 2002

On 2002-04-11 20:18, d2100 wrote:
Is there an alternative to using an apostrophe or single quote to designate a quantity or number as a label?

Hi d2100:
I am not sure about the purpose or the context of your question, but the # symbol is used in some cases instead of ' symbol!