How to change the sum (number) of a column to written text. (XP Professional
- Excel)
We use a syntax/switch "CardText \*..... (XP Professional - Word)
How to change the sum (number) of a column to written text. (XP Professional
- Excel)
We use a syntax/switch "CardText \*..... (XP Professional - Word)
http://www.xldynamic.com/source/xld.xlFAQ0004.html
--
Kind regards,
Niek Otten
"Mani K" <[email protected]> wrote in message
news:[email protected]...
> How to change the sum (number) of a column to written text. (XP
> Professional
> - Excel)
> We use a syntax/switch "CardText \*..... (XP Professional - Word)
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks