Alternative to apostrophe?

d2100 · Apr 11th, 2002, 09:18 PM

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

Tom Urtis · Apr 11th, 2002, 09:42 PM

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 11th, 2002, 09:50 PM

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 11th, 2002, 09:53 PM

Quote:

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!

Apr 11th, 2002, 09:42 PM	#2
Tom Urtis MrExcel MVP Join Date: Feb 2002 Location: San Francisco, California USA Posts: 10,388	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? __________________ Tom Urtis Microsoft MVP - Excel

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 11th, 2002, 09:18 PM	#1
d2100 New Member Join Date: Apr 2002 Posts: 1	Is there an alternative to using an apostrophe or single quote to designate a quantity or number as a label?

Apr 11th, 2002, 09:50 PM	#3
spg2112 Board Regular Join Date: Feb 2002 Location: Dallas, TX Posts: 312	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