Cell referenced as text

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

have cell A1 formatted as a number with 12.34 in it. Want to have cell B1
reference A1, but be formatted as text so it can be used for other purposes.
How can this be done?
 
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

CONDITIONAL FORMATTING QUERY 0
Duff Date Text 3
Clever formula required to sum contents of cell 6
somewhat complicated conditional formula 2
Constant date in one cell 1
Count of Font Format 1
CF on Consecutive cells 1
Create static text from cell reference 2

Back
Top