convert text to number

AllenL · Mar 22nd, 2002, 01:27 PM

Question:
Is there a formula that can let me convert text-number to number?
ie: 34.5# to 34.5
Thanks in advance

Mark W. · Mar 22nd, 2002, 01:29 PM

Just add zero.

="34.5"+0

Or, use the VALUE function...

=VALUE("34.5")

[ This Message was edited by: Mark W. on 2002-03-22 12:31 ]

AllenL · Mar 22nd, 2002, 01:35 PM

Hello Mark
I am in auto filer setting now. And I have one column with text-number and one blank column.
I tried both methods but they all give me a "#Value!" error
Did I miss any step?

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

Mar 22nd, 2002, 01:27 PM	#1
AllenL Board Regular Join Date: Mar 2002 Posts: 67	Question: Is there a formula that can let me convert text-number to number? ie: 34.5# to 34.5 Thanks in advance

Mar 22nd, 2002, 01:29 PM	#2
Mark W. MrExcel MVP Join Date: Feb 2002 Location: Austin, Texas USA Posts: 11,654	Just add zero. ="34.5"+0 Or, use the VALUE function... =VALUE("34.5") [ This Message was edited by: Mark W. on 2002-03-22 12:31 ]

Mar 22nd, 2002, 01:35 PM	#3
AllenL Board Regular Join Date: Mar 2002 Posts: 67	Hello Mark I am in auto filer setting now. And I have one column with text-number and one blank column. I tried both methods but they all give me a "#Value!" error Did I miss any step?