Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Zahid Khan
 
Posts: n/a
Default Converting 'General' formatted cells to Text formatted cell using.

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.


  #2   Report Post  
Gord Dibben
 
Posts: n/a
Default

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.


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
I want Excel to allow cells with formulas and unrelated text blueboy Excel Discussion (Misc queries) 9 March 4th 05 01:22 AM
i have fields that are formatted for text that randomly convert t. dave glynn Excel Discussion (Misc queries) 2 February 22nd 05 10:03 PM
Converting Numbers to Text properly Shirley Munro Excel Discussion (Misc queries) 1 February 16th 05 04:01 PM
roundoff when converting text to numbers Jack Excel Worksheet Functions 3 January 30th 05 02:51 AM
Convert data of cells to any type: Number, Date&Time, Text Kevin Excel Discussion (Misc queries) 0 December 30th 04 07:55 AM


All times are GMT +1. The time now is 01:31 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"