text > number
VBA Telemetry pings you when your VBA projects fail
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 7 of 7

Thread: text > number

  1. #1
    Board Regular
    Join Date
    Mar 2002
    Posts
    1,451
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    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

  2. #2
    Board Regular
    Join Date
    Feb 2002
    Location
    Brisbane, Down Under
    Posts
    542
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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. #3
    Board Regular
    Join Date
    Mar 2002
    Posts
    1,451
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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. #4
    Board Regular
    Join Date
    Mar 2002
    Location
    India
    Posts
    50
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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. #5
    Board Regular
    Join Date
    Mar 2002
    Posts
    1,451
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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. #6
    Board Regular
    Join Date
    Feb 2002
    Location
    Brisbane, Down Under
    Posts
    542
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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. #7
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Newcastle, UK
    Posts
    1,174
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    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

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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

 

 
DMCA.com