numbers don't add up
Amazing chart utilities from Jon Peltier
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 10 of 10

Thread: numbers don't add up

  1. #1
    Guest

    Default

     
    after importing some data I am unable to use this data im my formulas untill I edit the data in the cell. ANY IDEAS ?

  2. #2
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Austin, Texas USA
    Posts
    11,654
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Perhaps you're "importing" your numeric values as text (i.e., "10"). Use the Data | Text to Columns... menu command to convert them back to numeric values.

  3. #3
    Guest

    Default

    that's not the problem its as if there's an unspecified character in the cell
    if I do a delete before my entry and after my entry then it works fine

    eg [del]12[ lots of dels ]

    but nothing shows up as being in those cells
    I've used TRIM() to remove spaces but that does not work

  4. #4
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Austin, Texas USA
    Posts
    11,654
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    So what are these mysterious characters? Using the array formula...

    {=CODE(MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1))}

    ...for a value in A1, paste the resultant array constant into a reply posting. You can evaluate with formula in the formula bar using F9.





    [ This Message was edited by: Mark W. on 2002-02-25 07:36 ]

  5. #5
    Guest

    Default

    I get a result of 32

  6. #6
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Austin, Texas USA
    Posts
    11,654
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-02-25 07:53, Anonymous wrote:
    I get a result of 32
    32 is a space character. What about the rest of the codes?

  7. #7
    Guest

    Default

    ={32;32;32;32;49;55;49;46;32;48}

  8. #8
    Guest

    Default

    On 2002-02-25 07:57, Anonymous wrote:
    ={32;32;32;32;49;55;49;46;32;48}
    It appears that you have leading spaces and a space after the decimal place. Have you tried using the Replace command to replace " " with "".

  9. #9
    Guest

    Default

    i spotted this just before you posted but thanks for the help. I do get other similar problems which I can't see an answer to , it may be later in the week before I have to import the data again . If the error occurs I'll post it here again.

    Cheers Stephen

  10. #10
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Austin, Texas USA
    Posts
    11,654
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    Hang on to the formula that I provided and you can use it to diagnose your problem.

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