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!
Have you tried Find & Replace?
Entia non sunt multiplicanda sine necessitate
Do a Find and Replace
Ctrl+H
Enter /1000 in the Find what:
Leave Replace with: blank
Click Replace All
Last edited by mdbct; 04-21-2010 at 02:27 PM.
Wow... didn't realize you could replace with a blank, haha. That worked
You guys are great, this forum is a huge help!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks