Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Converting numbers to text
Is there any formula (if so, I can't find it) that will convert currency in
one cell to text in another cell? I mean that, for example, if I type ‚¬15,25 in one cell that the other cell reads "fifteen euro 25 ct." If the formula exists for the Dutch language it would be just perfect. |
#2
|
|||
|
|||
See http://www.xldynamic.com/source/xld.xlFAQ0004.html
-- HTH RP (remove nothere from the email address if mailing direct) "Ewout Stoutjesdijk" <Ewout wrote in message ... Is there any formula (if so, I can't find it) that will convert currency in one cell to text in another cell? I mean that, for example, if I type ?15,25 in one cell that the other cell reads "fifteen euro 25 ct." If the formula exists for the Dutch language it would be just perfect. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
about converting numbers to text. | Excel Discussion (Misc queries) | |||
Cells formated as numbers are calculating like text | Excel Discussion (Misc queries) | |||
Concantenate Text with numbers with fixed form | Excel Worksheet Functions | |||
how to format numbers stored as text or vice versa to use vlookup | Excel Worksheet Functions | |||
converting numbers to text and prefill text field with 0's | Excel Discussion (Misc queries) |