I need to find all cells in a spread sheet which contain .0001 and delete the value, leaving the cell empty. I'm not wanting to delete the row, column or cell...just delete the value in the cell.
I need to find all cells in a spread sheet which contain .0001 and delete the value, leaving the cell empty. I'm not wanting to delete the row, column or cell...just delete the value in the cell.
Ctrl+H, Find .0001, Replace With nothing
Make Mom proud: Add to my reputation if I helped out!
Make the Moderators happy: Mark the Thread as Solved if your question was answered!
Thank you for the reply. I had tired that earlier with Ctrl + F and it does place a =0 for the value. Ctrl + H did the same thing. Can it be left blank...as an empty cell? I tried replacing with " " but it didn't accept that solution.
Ctrl+H, Find 0.0001, Replace With nothing
or a combination of
Ctrl+H, Find 0.0001, Replace With nothing and then
Ctrl+H, Find .0001, Replace With nothing
Willem
English is not my native language sorry for errors
Please correct me if I'm completely wrong
Adding the zero in front of the decimal did the trick. Thank you for the help.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks