Digits to character...!!!

[usm]

Hi 2 all,

I have a figure (e.g 2755$) in a cell. i want this figure automatically in words in any other cell (e.g twenty seven hundred and fifty five).

Is there any kind assistance...
Thanx

[Light]

Not my answer, but I found it in another post here

Norman Jones" wrote:

> Hi KC,
>
> You could download Laurent Longre's MoreFunc addin which is freely
> downloadable at:
>
> http://xcell05.free.fr/
>
> The addin includes the NBTEXT function which converts a positive number into
> spelled-out text (supports 13 languages).
>
> Also see:
> http://support.microsoft.com/default...b;en-us;213360
> 'How to convert a numeric value into English words in Excel'
>
> and
> http://support.microsoft.com/?scid=kb;en-us;259663
> 'How To Convert Currency or Numbers into English Words'
>
> If you are not familiar with macros, you may wish to visit David McRitchie's
> 'Getting Started With Macros And User Defined Functions' at:
> http://www.mvps.org/dmcritchie/excel/getstarted.htm
>
>
> ---
> Regards,
> Norman


"usm" wrote:

>
> Hi 2 all,
>
> I have a figure (e.g 2755$) in a cell. i want this figure automatically
> in words in any other cell (e.g twenty seven hundred and fifty five).
>
> Is there any kind assistance...
> Thanx
>
>
> --
> usm
> ------------------------------------------------------------------------
> usm's Profile: http://www.excelforum.com/member.php...o&userid=34697
> View this thread: http://www.excelforum.com/showthread...hreadid=545032
>
>

[mudraker]

Another site that has vba code to convert numbers to text

http://www.ozgrid.com/VBA/ValueToWords.htm