Error Checking in Excel
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.

Some videos you may like

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
  •