Converting 'General' formatted cells to Text formatted cell using.

Z

Zahid Khan

How do I send data from a 'General' formatted cell to a 'text' formatted
cell? The end result required is a cell in 'text' format displaying the sent
data.

I wish to use a formula to do this, instead of using right-click, format
cells, select 'Text' as format.
 
G

Gord Dibben

Zahid

Assuming the number 1234.78 in A1 formatted as General.

In B1 enter =TEXT(A1,"0.00")

BTW....you can't "send" data from one cell to another using a formula.

You can only return a value into a cell which has the formula.


Gord Dibben Excel MVP

On Sat, 12 Mar 2005 10:31:05 -0800, "Zahid Khan" <Zahid
 

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

Excel does not accept text format! 0
Paste to excel from word - auto format problem 1
Peculiar default cell format 1
Place picture in Excel cell 0
Select Text to End of Footnote 9
Show a cell's formula in text format in a linked cell 2
How can i put text in a cell depending on colour 0
Word Mail Merge - keeping paragraph breaks that appear in original Excel cell data 2

Top