cell formatting

[jnu]

is there a way to format a cell such as: enter 2378 -- two thousand three
hundred seventy-eight appears

[JudithJubilee]

Hello jnu,

There is no easy way to do this but check out thos site for the code:

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

Judith
--
Hope this helps


"jnu" wrote:

> is there a way to format a cell such as: enter 2378 -- two thousand three
> hundred seventy-eight appears

[jnu]

i guess i meant enter in one cell and appear in another. the
=spellnumber(a1) would work but i got #name?. i'm using XP

"JudithJubilee" wrote:

> Hello jnu,
>
> There is no easy way to do this but check out thos site for the code:
>
> http://www.ozgrid.com/VBA/ValueToWords.htm
>
> Judith
> --
> Hope this helps
>
>
> "jnu" wrote:
>
> > is there a way to format a cell such as: enter 2378 -- two thousand three
> > hundred seventy-eight appears