PLEASE HELP!!! I cant convert a cell to text for some reason.

J

Jason Stirret

I'm not the greatest with excel but I would consider myself a solid intermediate user so I should understand any advise I hope to get from this post!

I have numbers (values anyway) in a few cells that I ran an ISTEXT functionon, which came back FALSE; ran ISNUMBER comes back TRUE. To me self explanatory...convert the cell to "text and I'm good. Foe whatever reason I cannot convert the cell. I run the same thing and its still not text but a number. The sheet has no protection and I need to convert everything in this rowto number.

Any ideas? Haven't run into this before and I'm stuck!

Really appreciate any help I can get 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

Convert Cell Text to Matching Hyperlink????? 5
Help - Excel 97 Macro convert Text to Number 6
Vlookup Error, how to convert Text to Number 15
Converting text to cell reference and column letters to numbers -please help 6
Trying to convert text to number 3
convert column to a cell with formatting 3
I type in a number in a cell but it wont convert to currency help 2
Find numeric characters found within cell text and convert tohyperlink 1

Top