cell formula or formatting
 

is there a formula or cell format so that when i type 389 in cell A1, three
hundred and eighty-nine appears in cell b3

cell formula or formatting
 

jnu

Not sure if this is what you're asking for, but if you go to cell b3 and
enter (Without quotation marks)

"=A1"

Then anything you put into A-1 will appear in B3.

You can also arrange for formulas to be completed this way... if, say, cells
A-1 and A-2 are numbers you want to add, then in A-3 you can type "=A1+A2"
and it will add anything put into A-1 and A-2 (The 'SUM' function can also
be used).

HTH

Shane
"jnu" wrote in message
...
is there a formula or cell format so that when i type 389 in cell A1,
three
hundred and eighty-nine appears in cell b3

cell formula or formatting
 

i'm wanting to setup a checkbook. so i just have to enter the number(120) in
one cell "A1" and like "One hundred and twenty dollars appears in b3

"SV" wrote:

jnu

Not sure if this is what you're asking for, but if you go to cell b3 and
enter (Without quotation marks)

"=A1"

Then anything you put into A-1 will appear in B3.

You can also arrange for formulas to be completed this way... if, say, cells
A-1 and A-2 are numbers you want to add, then in A-3 you can type "=A1+A2"
and it will add anything put into A-1 and A-2 (The 'SUM' function can also
be used).

HTH

Shane
"jnu" wrote in message
...
is there a formula or cell format so that when i type 389 in cell A1,
three
hundred and eighty-nine appears in cell b3

cell formula or formatting
 

OK, that's not so bad, either.

Click inside B3 so the cell is highlighted. Select "Format Cells" and the
"Format" box will appear.
Click the "Numbers" tab and on the left you'll see a list of options for
formatting numbers. On the right is specific options within those number
types.
Click on "Currency" and and the Currency options will appear. Select "$"
and 2 decimal places (or none, if you prefer) and click "OK" Now the cell
is set up to display in dollars (You can do the same with A-1 if you want,
too!)

Then, as I said before, just use the "=A1" formula in that cell, and
whatever number you type in A-1 will appear, as "$..." in B-3, so "120" in
A-1 would cause B-3 to display "$120"

Does that help?

Shane

"jnu" wrote in message
...
i'm wanting to setup a checkbook. so i just have to enter the number(120)
in
one cell "A1" and like "One hundred and twenty dollars appears in b3

"SV" wrote:

jnu

Not sure if this is what you're asking for, but if you go to cell b3 and
enter (Without quotation marks)

"=A1"

Then anything you put into A-1 will appear in B3.

You can also arrange for formulas to be completed this way... if, say,
cells
A-1 and A-2 are numbers you want to add, then in A-3 you can type
"=A1+A2"
and it will add anything put into A-1 and A-2 (The 'SUM' function can
also
be used).

HTH

Shane
"jnu" wrote in message
...
is there a formula or cell format so that when i type 389 in cell A1,
three
hundred and eighty-nine appears in cell b3

cell formula or formatting
 

Visit Bob Phillips' site for info on this subject.

Several links to methods, all of which involve VBA.

http://www.xldynamic.com/source/xld.xlFAQ0004.html


Gord Dibben MS Excel MVP

On Mon, 11 Dec 2006 09:14:00 -0800, jnu wrote:

is there a formula or cell format so that when i type 389 in cell A1, three
hundred and eighty-nine appears in cell b3

cell formula or formatting
 

Wow, I had completely NOT caught the spelling out portion of the initial
post! Call me Mr. Oversight

:-)

Shane

"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
Visit Bob Phillips' site for info on this subject.

Several links to methods, all of which involve VBA.

http://www.xldynamic.com/source/xld.xlFAQ0004.html


Gord Dibben MS Excel MVP

On Mon, 11 Dec 2006 09:14:00 -0800, jnu
wrote:

is there a formula or cell format so that when i type 389 in cell A1,
three
hundred and eighty-nine appears in cell b3