Re: How do I replace numbers in a value NOT a formula?

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Change the formulas !

OR

If you don't need the formulas for any *further* calculations,
Select the formulas,
right click in the selection,
Choose "Copy",
Right click again and choose "Paste Special",
Click on "Values", then <OK>.

Now you can edit and replace the 0's with blanks,

Which is *EXACTLY* the same as *DELETING* the formulas in the first
place.<g>

OR

Change the formulas !
--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================

"Riverrat" <Riverrat@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:7E80190B-BBFA-4F6C-92A3-A698EFF6F9AB@xxxxxxxxxxxxxxxx
I want to replace zeros with blanks. In the Find tab of the Find/Replace
dialog box I can choose to find the zeros in values as opposed to formulas.
However, when I go to the Replace tab, the only option it gives me is to
replace zeros found in formulas. How can I replace only zeros that show up
as values RESULTING from formulas?


.

Relevant Pages

  • Re: Help Decoding HEX Registry Entry
    ... without even the implied warranty of merchantability ... In this case the OP's data string doesn't fully alternate 0's throughout. ... Probably better ro eliminate the zeros ... This retains the "9" as a tab, ...
    (microsoft.public.scripting.vbscript)
  • Re: Linking worksheets
    ... I am trying to do the same thing again and now I can't figure out how to get rid of the ZEROS. ... I see the box to SKIP blank cells but when I click on PASTE LINK, that box is no longer available. ... I would like for the second tab to display the data in columns A thru H on ...
    (microsoft.public.excel.misc)
  • Re: Displaying leading zeros in an Excel spreadsheet
    ... before entering the numbers select the range and choose format / cells - ... on the numbers tab click custom and in the white line on the right type ... > How can I display leading zeros in an Excel spreadsheet? ...
    (microsoft.public.excel.misc)
  • mail merge in publisher using txt data source
    ... I am trying to merge an excel data source to publisher including various ... When merging, the tab does not work as a separator. ... zeros when merged. ...
    (microsoft.public.publisher)
  • A number formatted as text is not recognized in a vlookup.
    ... In a multi-tabbed workbook, we have product numbers (some with leading zeros ... On another tab, using a vLookup function that worked in Office ... formatted as text to avoid dropping leading zeros. ...
    (microsoft.public.excel.misc)