Replacing Zeros

  • Thread starter Thread starter ExcelMonkey
  • Start date Start date
E

ExcelMonkey

I want to replace the zeros in a column. However I only want the zer
replaced if it is a stand alone zero ie, "0". If it is "40" I want i
left alone. How do you do this with the Replace dialogue under Edi
Replace? I get the impression that there must be a whole set of synta
that one can use with replace to put conditions on it. Does anyon
know where i can find this?

thank
 
In Excel 2003, there are OPTIONS under find/replace where you can specify
that you are looking only for cells where the entire content is 0.

I don't know what ver you have, even then, if previous versions had this
option.
 
If you put a tick in the box "Find entire cells only" It should work.


Pet
 
ExcelMonkey

Edit | Replace | Find what: 0; Replace with: (leave empty) and tick Find
Entire cells only

Regards

Trevor
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Stripping leading zeros 2
MS word Find and Replace using Regex - Help required 0
Replace zero values with blank 3
Excel 2007 Replace and single quotes 5
Find/Replace - from old to new 1
replacing zeros by blank cells 5
Excel converts text cell contents to numbers (strips leading zeros)???!!! 1
Replacing Contents in Cells 2

Back
Top