Gusty
08-15-2011, 09:05 AM
Hi everyone. Bit of a head scratcher here after day of converting pdf files to excel. I need to convert the euro number format to uk format and have been trying the substitute command. It seems to work on most of the numbers except ones ending in zero. i have attached an extract showing the incorrect values in cells h7 h9 etc. Is there a better way of doing this?
Any advice greatly received!
Any advice greatly received!