text > number

verluc · Apr 9th, 2002, 04:55 AM

I have downloaded a sheet with numbers.
Some of those numbers are created as TEXT
Who can write a formula that automatickly these TEXT convert to a NUMBER?
Thanks in advance

SamS · Apr 9th, 2002, 05:06 AM

Wherever you have numbers imported as text add 1 to it to convert it eg =A1+0 will do the trick where A1 is the cell that has come in as text.

verluc · Apr 9th, 2002, 05:10 AM

Quote:

On 2002-04-09 04:06, SamS wrote:
Wherever you have numbers imported as text add 1 to it to convert it eg =A1+0 will do the trick where A1 is the cell that has come in as text.

Can you give me an example.
I have for instance 12 in Cell A10 as text
I have to turn it in 12 as number.
Many thanks

sam_d1 · Apr 9th, 2002, 05:34 AM

I am not sure why you want to convert the number (in text form) to number form.
If it is for using the number in calculations, It can be done without converting.

verluc · Apr 9th, 2002, 05:37 AM

Quote:

On 2002-04-09 04:34, sam_d1 wrote:
I am not sure why you want to convert the number (in text form) to number form.
If it is for using the number in calculations, It can be done without converting.

Great,its works with adding 0 to the formule
1000 X thanks.

SamS · Apr 9th, 2002, 05:38 AM

Quote:

On 2002-04-09 04:10, verluc wrote:

Quote:

On 2002-04-09 04:06, SamS wrote:
Wherever you have numbers imported as text add 1 to it to convert it eg =A1+0 will do the trick where A1 is the cell that has come in as text.

Can you give me an example.
I have for instance 12 in Cell A10 as text
I have to turn it in 12 as number.
Many thanks

In B10 (or wherever you want the number) type =A10+0. Sam_D1 is also correct if you are using it in calculations. The problem occurs when you need to use lookup tables etc.

[ This Message was edited by: SamS on 2002-04-09 04:39 ]

Ian Mac · Apr 9th, 2002, 05:41 AM

Another way,

Put 1 in any cell, copy it
Highlight the areas with nums and text,
Right-Click, Paste Special
Check the multiply option, OK.

Should do the trick without have to move your data around.

Apr 9th, 2002, 05:41 AM	#7
Ian Mac MrExcel MVP Join Date: Feb 2002 Location: Newcastle, UK Posts: 1,174	Another way, Put 1 in any cell, copy it Highlight the areas with nums and text, Right-Click, Paste Special Check the multiply option, OK. Should do the trick without have to move your data around. __________________ "Have a good time......all the time" Ian Mac

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

Apr 9th, 2002, 04:55 AM	#1
verluc Board Regular Join Date: Mar 2002 Posts: 1,288	I have downloaded a sheet with numbers. Some of those numbers are created as TEXT Who can write a formula that automatickly these TEXT convert to a NUMBER? Thanks in advance

Apr 9th, 2002, 05:06 AM	#2
SamS Board Regular Join Date: Feb 2002 Location: Brisbane, Down Under Posts: 533	Wherever you have numbers imported as text add 1 to it to convert it eg =A1+0 will do the trick where A1 is the cell that has come in as text.

Apr 9th, 2002, 05:34 AM	#4
sam_d1 Board Regular Join Date: Mar 2002 Location: India Posts: 50	I am not sure why you want to convert the number (in text form) to number form. If it is for using the number in calculations, It can be done without converting.