I have a spreadsheet with a couple thousand cells that bring data in from another sheet and divide it by 1000. I need the data to not be divided by 1000. Other than multiplying each cell by 1000 using copy > paste special, is there a way to remove the /1000 in the cells?
Looks like:
='File Name'!A123/1000
Need to get rid of that last part (/1000) and don't want to go into each cell and delete it out.
Thoughts?
Thank you!
Bookmarks