format problem

  • Thread starter Thread starter vikram
  • Start date Start date
V

vikram

I have a file of 50000 rows and in column A in just 2 or three cells
i have a cell which show #NAME? but if u click that cell it will sho
=- vikram, how to get rid of this cell...i mean to say that how t
format that cell to a eadable format

thank
 
Nothing wrong with the format (at least I don't think so), you just don't have a
named range or value of vikram.
 
but i want to get rid of cells which show #NAME? this value
how to do tha
 
Either assign a range or value to vikram or do a find =-vikram replace (blank
or 0 or whatever you want to show there) Replace all

: but i want to get rid of cells which show #NAME? this value
: how to do that
:
:
: ---
: Message posted
:
 
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

Remove date format? 3
Excel VBA 1
COPYING CONDITIONAL FORMATTING WHEN COPYING CELLS OVER 2
Excel Conditional Formatting 1
complex count formulas using multiple criteria in different ranges 4
Quote Marks Question 2
conditional formatting in Excel 2007 1
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0

Back
Top