Hi, i have an enclosed file which has a column of numbers in it like this
389,40 and this number should be represented like this 389.40
i read somehwere online that if you use the CDbl function that it will automatically replace comma with "local decimal" separator.....
but for me its not.......
for me 389,40 shows up as 38940.00
Basically anythoughts on how to convert number from 389,40 to 389.40
If its just a simple "find/replace" then is there a test or something i can do to make sure i am not replacing a numeric value where a comma exists but its not representing a decimal separator?
Bookmarks