Results 1 to 5 of 5

different decimal points when values should be the same

Threaded View

  1. #1
    Forum Contributor
    Join Date
    08-04-2010
    Location
    singapore
    MS-Off Ver
    Excel 2007
    Posts
    143

    different decimal points when values should be the same

    Hi,

    i have attached an example copy. currently,the values in sheet(auto selection) are copied from sheet(raw data) using the auto selection button in sheet(raw data). then, i have copied the rows in sheet(auto selection) into (hidden) as well as all the rows in sheet(raw data) into sheet(hidden).duplicated rows are supposed to be highlighted in red as shown in the hidden sheet. however, in row 17 to row 20 are not highlighted. it is because for row 17, the value of column c is 6831.4909 while value of column c of row 32 is 6831.49090909089. does anybody know what is wrong with my coding? how can i change my coding to make sure that the decimals for sheet(raw data) and sheet( auto selection) are identical?

    thank you.
    Attached Files Attached Files
    Last edited by dan2010; 11-07-2010 at 06:19 AM. Reason: adding attachment

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