cell formatting
 

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

cell formatting
 

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

cell formatting
 

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