Gord Dibben wrote:
Just copy the formula down from C3 as far as you wish.

Grab the fill handle of C3 and drag down.

The fill handle is the little blank lump you see at bottom right corner of the
cell.

Left-click on that and drag.

In case there are no numbers yet in column C enter this in D3.

=IF(ISNUMBER(C3),C3*5%,"")

You are still stating that .05 percent of 100 is 5 which is incorrect.

5% of 100 is 5

One way:

[quoted text clipped - 17 lines]
"C" in each of these 15 rows, I would want the formula of 5% to appear in
column "D".


I did as instructed and it worked. Thanks 1,000,000!!! One thing I noticed
was that the $ sign and .00 cents do not show in column "C" when I type in 55.
00. However the cents .00 do show in column "D". How do I get the $ sign
and the .00 cents to appear in column "C" when I type it?

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200707/1

One way:

Select all of column C (or the cells in Column C where you're going to
be inputting your data). Format it the way you want with $ and fixed
decimal places.

In article <75e1a121aec7d@uwe,
"poppiekat via OfficeKB.com" <u36195@uwe wrote:

How do I get the $ sign and the .00 cents to appear in column "C"
when I type it?

JE McGimpsey wrote:
One way:

Select all of column C (or the cells in Column C where you're going to
be inputting your data). Format it the way you want with $ and fixed
decimal places.

How do I get the $ sign and the .00 cents to appear in column "C"
when I type it?

Could you please show me the exact formula I need to enter for doing this?

--
Message posted via http://www.officekb.com

poppiekat wrote:
One way:

[quoted text clipped - 4 lines]
How do I get the $ sign and the .00 cents to appear in column "C"
when I type it?

Could you please show me the exact formula I need to enter for doing this?
Please ignore my ignorance.....I see now that you said "format" and I was so
frustrated after a long day of dealing with things that I could only read the
word "formula".

I formated the cells with currency $ and two digits .00 and everything is
working just fine.
Your're the greatest !!!

--
Message posted via http://www.officekb.com