I have a spreadsheet which has numbers with decimal thousand seperators rather than commas e.g. 178.455.136. If I do a find and replace I get 178,455,136 which is fine.
However there are some numbers e.g. 83.58 which needs to change to 83,580. I can change the number of decimal places of the original to 83.580 but when I do a find and replace it goes back to 83,58. There are also some numbers e.g. 972 which should be 972,000 or 59.3 which should be 59,300. I guess what I probably want is a way to force the original data to have the correct number of zeros at the end.
Hopefully there is a simple solution to this as i don't want to have to go through and add zeros manually.
Thanks for any help,
Lou
However there are some numbers e.g. 83.58 which needs to change to 83,580. I can change the number of decimal places of the original to 83.580 but when I do a find and replace it goes back to 83,58. There are also some numbers e.g. 972 which should be 972,000 or 59.3 which should be 59,300. I guess what I probably want is a way to force the original data to have the correct number of zeros at the end.
Hopefully there is a simple solution to this as i don't want to have to go through and add zeros manually.
Thanks for any help,
Lou