We have Excel 2010 and Access 2010.
I exported some data from my Access database into an Excel spreadsheet named Example.xls. In column A I have reference numbers, but some of the numbers are formatted wrong and I need to change them.
I need to remove the .0 from the end of any number. In my attachment, I have highlighted the numbers which need to be changed with code. For example the number 2014800136156.0 needs to be changed to 2014800136156.
Can anyone provide me with the code to change these numbers in column A automatically through vba macro.
Thanks in advance.