Hi everyone, I need to know how to translate numbers into letter. I'm using
windows 2K and office 2003
What quot;valuequot; do you want the letters to have?
--
Regards
Sandy
with @tiscali.co.uk
quot;Albertquot; gt; wrote in message
...
gt; Hi everyone, I need to know how to translate numbers into letter. I'm
gt; using
gt; windows 2K and office 2003
=Char(65) ... returns quot;Aquot;
65 to 90 equals A to Z
97 to 122 equals a to z
--
Jim Cone
San Francisco, USA
www.realezsites.com/bus/primitivesoftwarequot;Albertquot; gt;
wrote in message
...
Hi everyone, I need to know how to translate numbers into letter. I'm using
windows 2K and office 2003
Albert,
do you mean single letters 1-26, i.e a=1, b-2, ....z =26 etc?
or a more complicated example.
please explain?
Albert wrote:
gt;Hi everyone, I need to know how to translate numbers into letter. I'm using
gt;windows 2K and office 2003
--
Message posted via OfficeKB.com
www.officekb.com/Uwe/Forums.a...excel/200603/1
Albert Wrote:
gt; Hi everyone, I need to know how to translate numbers into letter. I'm
gt; using
gt; windows 2K and office 2003Hi Albert,
Adding to the other answers:
How to convert a numeric value into English words in Excel.
support.microsoft.com/default...b;en-us;213360--
Desert Piranha------------------------------------------------------------------------
Desert Piranha's Profile: www.excelforum.com/member.php...oamp;userid=28934
View this thread: www.excelforum.com/showthread...hreadid=526877
- Oct 18 Sat 2008 20:47
Convert numbers into leters
close
全站熱搜
留言列表
發表留言