Alternative to apostrophe?

[d2100]

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

 

[Tom Urtis]

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]

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]

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!