Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
function to convert whole numbers to written text
How to change the sum (number) of a column to written text. (XP Professional
- Excel) We use a syntax/switch "CardText \*..... (XP Professional - Word) |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
function to convert whole numbers to written text
http://www.xldynamic.com/source/xld.xlFAQ0004.html
-- Kind regards, Niek Otten "Mani K" wrote in message ... How to change the sum (number) of a column to written text. (XP Professional - Excel) We use a syntax/switch "CardText \*..... (XP Professional - Word) |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
function to convert whole numbers to written text
Hi Mani, If column A has figures and you want their sum in B1 put the following function in B1 =TEXT(SUM(A:A),"Rs.0.00") instead of total coloum A:A you can give the range for which u want sum You may go through the Microsoft Excel Help for TEXT or any other function with following steps starting from Menu toolbar Instert Function type the function TEXT or any other function in the box click go click Help on this function below regards, gandhi -- gandhi318Posted from - http://www.officehelp.in |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Convert Numbers to Text | Excel Worksheet Functions | |||
How can I convert Text into numbers? | Excel Worksheet Functions | |||
Sorting numbers and text separately | Excel Discussion (Misc queries) | |||
convert numbers to text. | Excel Worksheet Functions | |||
Sort or Filter option? | Excel Worksheet Functions |