cell formatting

jnu · Mar 23, 2006

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

JudithJubilee · Mar 23, 2006

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

jnu · Mar 23, 2006

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