R
Rojee
How do I convert numbers into Text
E.g.
Number Text
1,000 One Thousand
E.g.
Number Text
1,000 One Thousand
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
B
Bob Phillips
T
tghcogo
just put a single apostrophe in front, eg '1000
tgh
tgh
R
Rojee
Thanks bob it helps me alot
-----Original Message-----
See
http://www.xldynamic.com/source/xld.xlFAQ0004.html
Convert Numbers To Text
--
HTH
RP
.
B
Bob Phillips
He wants to convert numeric values to the word equivalents, not just make
the cell text.
the cell text.
G
Guest
If the number 1000 is in A1:
=(text,A1,0000)
=(text,A1,0000)
I
icestationzbra
the poster of this one:
If the number 1000 is in A1:
=(text,A1,0000)
If the number 1000 is in A1:
=(text,A1,0000)