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
wrote:
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.