Thread: Number format
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Mani K
 
Posts: n/a
Default Number format
\*CardText
Displays results as cardinal text. The result is formatted in lowercase
letters unless you add a format switch to specify a different capitalization.
For example, { = SUM(A1:B2) \* CardText } displays "seven hundred ninety",
and { = SUM(A1:B2) \* CardText \* Caps } displays "Seven Hundred Ninety".
What is the similar syntax in Excel to display the sum in words?
Reply With QuoteReply With Quote