But I doubt it will fail for some cases when say the data will be like 4.001932 and 4.001134
the Round function will output the 4.002 and 4.001 which wil be wrong.
let me findout some other option.
can you try Mid function, just in case you are getting data from excel as string.
also always wrap up your code with proper tags while posting
the Round function will output the 4.002 and 4.001 which wil be wrong.
let me findout some other option.
can you try Mid function, just in case you are getting data from excel as string.
also always wrap up your code with proper tags while posting