+ Reply to Thread
Results 1 to 3 of 3

Value not recognized as value

  1. #1
    Registered User
    Join Date
    02-09-2004
    Location
    The Netherlands
    Posts
    46

    Value not recognized as value

    Hi all,

    I have a spreadsheet in which I have to sum some values. However, the outcome is always zero since Excel doesn't seem to recognize the values as values.
    These values are originally values with a dot, which I've searches and replaces by a comma, because in the Netherlands, we use comma's as decimal point.
    If I go INTO a cell with a value, and press enter, then it suddenly do see a value.
    But, as I have thousands of cells with values, I was wondering if there is a better way to force Excel to see these cells as values.

    TIA,

    Annet

  2. #2
    Forum Contributor
    Join Date
    04-11-2005
    Location
    London
    Posts
    259
    http://support.microsoft.com/default...22120121120120

    I tried it out. The Error button and the Clean/Trim method works quite well.

    MS

  3. #3
    Registered User
    Join Date
    02-09-2004
    Location
    The Netherlands
    Posts
    46
    Thanks very much! I've used this code

    Sub Enter_Values()
    For Each xCell In Selection
    xCell.Value = xCell.Value
    Next xCell
    End Sub

    and now my problem is solved.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1