close

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

arrow
arrow
    全站熱搜
    創作者介紹
    創作者 software 的頭像
    software

    software

    software 發表在 痞客邦 留言(0) 人氣()