I have a column which contains a number of cells in excel, that contains comma delimited strings of numbers in this format eg 843.64,746.75,1117.34,729.95,2438.32,808.05
I am trying to remove the decimal places.
I have tried formatting as number and setting decimal to 0 etc with no success. Not sure if it is something to do with the 1000 delimiter or not. This is what happens 8.44747111773024E+89..
Any suggestions?