Thanks:  0
Likes:  0

Some of those numbers are created as TEXT
Who can write a formula that automatickly these TEXT convert to a NUMBER?

2. 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.

3. 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

4. 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.

5. 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.

6. On 2002-04-09 04:10, verluc wrote:
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 ]

7. 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.

## User Tag List

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•