| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
converting a number into text
show with example how to change a number of 1 cell into a text form in the
another cell ? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
converting a number into text
With your number in A1, insert the following formula where you want the
conversion done. Right aligned "10" in A1 will become left aligned (text) "10" in result cell =IF(ISNUMBER(A1),TEXT(A1,0),A1) -- Hth Kassie Kasselman Change xxx to hotmail "wrashna ryvuh gurung" wrote: show with example how to change a number of 1 cell into a text form in the another cell ? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
converting a number into text
Sorry, it becomes A1=10 and another cell eg. B1=10.
I want A1=10 and another cell eg. B1=ten "Kassie" wrote: With your number in A1, insert the following formula where you want the conversion done. Right aligned "10" in A1 will become left aligned (text) "10" in result cell =IF(ISNUMBER(A1),TEXT(A1,0),A1) -- Hth Kassie Kasselman Change xxx to hotmail "wrashna ryvuh gurung" wrote: show with example how to change a number of 1 cell into a text form in the another cell ? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
converting a number into text
Awfully sorry I took so long to respond! Try the following for the ode required! http://support.microsoft.com/default...B;EN-US;213360 -- Hth Kassie Kasselman Change xxx to hotmail "padhma" wrote: Sorry, it becomes A1=10 and another cell eg. B1=10. I want A1=10 and another cell eg. B1=ten "Kassie" wrote: With your number in A1, insert the following formula where you want the conversion done. Right aligned "10" in A1 will become left aligned (text) "10" in result cell =IF(ISNUMBER(A1),TEXT(A1,0),A1) -- Hth Kassie Kasselman Change xxx to hotmail "wrashna ryvuh gurung" wrote: show with example how to change a number of 1 cell into a text form in the another cell ? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Converting number to text | Excel Discussion (Misc queries) | |||
| converting text to number | Excel Worksheet Functions | |||
| Converting number to text | Excel Discussion (Misc queries) | |||
| Converting Text to Number | Excel Discussion (Misc queries) | |||
| Converting text to a number | Excel Worksheet Functions | |||
Hybrid Mode
