#VALUE! return from format change

  • Thread starter Thread starter Elvis
  • Start date Start date
E

Elvis

I am trying the change the formatting of cells from General to Text. I am
inserting a new column, setting it to General, then use the formula
=TEXT(,AD2) and so on for the whole column. Some of those cells that contain
text and numbers (e.g. VN756) come back with the result of #VALUE! others do
not. I have just used Format Cells tool without success.

How do I make the cells data change to be text without returning the error
of #VALUE!?
Thank you,
Elvis
 

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

Format changes from "General" to "Text" 2
Remove date format? 3
For Joey2004 et al. From OP: Re Appending Question 3
Numbers change in cell even when formatted as text 4
Quote Marks Question 2
converting text cell to numeric cell 5
Formatting Cells 3
Conditional formatting 3

Back
Top