Results 1 to 8 of 8

Thread: Numbers not adding up!

  1. #1
    Seeker paultilling's Avatar
    Join Date
    Aug 2013
    Location
    London UK
    Posts
    9
    Articles
    0

    Numbers not adding up!



    Register for a FREE account, and/
    or Log in to avoid these ads!

    I sometimes find when I download an excel fiie from a website that the numbers in the cells do not respond as numbers although they appear as such.
    For instance they will not add up, they'll just give a '#Value!' sign in the summation cell. I then have to laboriously re-type each number over itself in order to get the excel sheet to function.
    Is there a way to get over this please? Am I doing something wrong during the download? Thanks in advance for any advice.

    Paul - AppleMac Air with Os X85 and ExcelMac 2011.

  2. #2
    Super Moderator NBVC's Avatar
    Join Date
    May 2011
    Location
    Mississauga, Canada
    Posts
    1,463
    Articles
    0
    Excel Version
    Excel 2016
    You can select a column, then go to Data|Text to Columns and simply hit Finish. This should coerce them to numbers.


  3. #3
    Seeker paultilling's Avatar
    Join Date
    Aug 2013
    Location
    London UK
    Posts
    9
    Articles
    0

    Numbers not adding up!

    Quote Originally Posted by NBVC View Post
    You can select a column, then go to Data|Text to Columns and simply hit Finish. This should coerce them to numbers.
    Thanks very much but it doesn't work! I select the column, go Data|Text to Columns and then 'finish' but it stays the same, ie the numbers still don't add up. The Data Wizard identifies the data as 'delimited' if that's any help.

    What do you think?

    Paul

  4. #4
    Super Moderator NBVC's Avatar
    Join Date
    May 2011
    Location
    Mississauga, Canada
    Posts
    1,463
    Articles
    0
    Excel Version
    Excel 2016
    Perhaps there are some bidden non printable chars. Try dong a CTRL+H and hold the ALT key while typing 032 using only the number pad.

  5. #5
    Seeker paultilling's Avatar
    Join Date
    Aug 2013
    Location
    London UK
    Posts
    9
    Articles
    0
    Quote Originally Posted by NBVC View Post
    Perhaps there are some bidden non printable chars. Try dong a CTRL+H and hold the ALT key while typing 032 using only the number pad.
    Thank you NBVC. I don't understand what you mean though. Cntrl H gives me a find & replace panel and I don't have a number pad. Can you explain what you mean please? Regards Paul

  6. #6
    Seeker paultilling's Avatar
    Join Date
    Aug 2013
    Location
    London UK
    Posts
    9
    Articles
    0
    The format inside the cell is obviously a text format - not a numeric format, but how to change it? Paul

  7. #7
    Super Moderator NBVC's Avatar
    Join Date
    May 2011
    Location
    Mississauga, Canada
    Posts
    1,463
    Articles
    0
    Excel Version
    Excel 2016
    Yes it is the find/replace tool. We want to replace any hidden character with a null in order to coerce numbers. By the number pad I mean the numbers at the right side of the keyboard and not across the top.


  8. #8
    Seeker paultilling's Avatar
    Join Date
    Aug 2013
    Location
    London UK
    Posts
    9
    Articles
    0
    Quote Originally Posted by NBVC View Post
    Yes it is the find/replace tool. We want to replace any hidden character with a null in order to coerce numbers. By the number pad I mean the numbers at the right side of the keyboard and not across the top.
    OK, I understand, so what can I do as I do not have a number pad? I presume the 032 is a carriage return but why can't I enter it from the top row? Paul

Tags for this Thread

Posting Permissions

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