Blank cell conversion to text

M

MaryMMG

If I have a column of blank cells, how do I formulate to make them read as
text?
 
J

JE McGimpsey

One way:

Select the column and choose Cells/Number/Text from the Format menu.
 

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

Footer text appears "squished" 1
Messages showing in "Find related" but not in Conversation view 0
Publisher adding blank page when printing my booklet... 2
Excel does not accept text format! 0
MS Word normal.dot cannot be fixed 'text box' appears each time 4
Select Text to End of Footnote 9
Excel 2013: How to ensure a cell is not left blank by users? (Not using VBA) 0
Cell data entering slow! 0

Top