I am working on an accounting spreadsheet (income statement to be exact). I
need to put a little asterix or numbers (1 2 3) behind several of values in
the cells indicating that there is a footnote on the bottom. Now if I just
put * it assumes that it will be multiplying so does anyone know how to do
this€¦. Ive never done it before in Excel so I am just stuck right now€¦

Also, is there a way to display brackets ( ) around a number indicating that
it will be subtracted without making the number negative? Again this is for
an income statement€¦ Thanks

For the second part:

Format Cells... Number Accounting
gets you brackets around negative values

Format Cells... Number Custom General"*"
get you a star!
--
Gary''s Student - gsnu200746


"Vanessa" wrote:

I am working on an accounting spreadsheet (income statement to be exact). I
need to put a little asterix or numbers (1 2 3) behind several of values in
the cells indicating that there is a footnote on the bottom. Now if I just
put * it assumes that it will be multiplying so does anyone know how to do
this€¦. Ive never done it before in Excel so I am just stuck right now€¦

Also, is there a way to display brackets ( ) around a number indicating that
it will be subtracted without making the number negative? Again this is for
an income statement€¦ Thanks

Gary,
When I go to Format Cells... Number Accounting it only asks for symbol
and decimal places...? I am not sure what to do once I'm there? Help
again...please :)

And ont he other one Format Cells... Number Custom General"*",,,
when I click General it only takes away the format I have on the curent
value... ?



"Gary''s Student" wrote:

For the second part:

Format Cells... Number Accounting
gets you brackets around negative values

Format Cells... Number Custom General"*"
get you a star!
--
Gary''s Student - gsnu200746


"Vanessa" wrote:

I am working on an accounting spreadsheet (income statement to be exact). I
need to put a little asterix or numbers (1 2 3) behind several of values in
the cells indicating that there is a footnote on the bottom. Now if I just
put * it assumes that it will be multiplying so does anyone know how to do
this€¦. Ive never done it before in Excel so I am just stuck right now€¦

Also, is there a way to display brackets ( ) around a number indicating that
it will be subtracted without making the number negative? Again this is for
an income statement€¦ Thanks

Use an extra column or insert a comment, if you put an asterisk there it
will be text.


--


Regards,


Peo Sjoblom




"Vanessa" wrote in message
...
Gary,
When I go to Format Cells... Number Accounting it only asks for
symbol
and decimal places...? I am not sure what to do once I'm there? Help
again...please :)

And ont he other one Format Cells... Number Custom General"*",,,
when I click General it only takes away the format I have on the curent
value... ?



"Gary''s Student" wrote:

For the second part:

Format Cells... Number Accounting
gets you brackets around negative values

Format Cells... Number Custom General"*"
get you a star!
--
Gary''s Student - gsnu200746


"Vanessa" wrote:

I am working on an accounting spreadsheet (income statement to be
exact). I
need to put a little asterix or numbers (1 2 3) behind several of
values in
the cells indicating that there is a footnote on the bottom. Now if I
just
put * it assumes that it will be multiplying so does anyone know how to
do
this.. I've never done it before in Excel so I am just stuck right now.

Also, is there a way to display brackets ( ) around a number indicating
that
it will be subtracted without making the number negative? Again this is
for
an income statement. Thanks

Hi,

for the first call my sugestion is to insert a thin column in the left or
right side of your numbers and enter (1,2,3,...) for the figurs that have note
and for the second call go to formatcells numbers costom and choos for
example #,##.0 and edit it by putting brackets like (#,##.00) in the type
text box
--
Farhad Hodjat


"Vanessa" wrote:

I am working on an accounting spreadsheet (income statement to be exact). I
need to put a little asterix or numbers (1 2 3) behind several of values in
the cells indicating that there is a footnote on the bottom. Now if I just
put * it assumes that it will be multiplying so does anyone know how to do
this€¦. Ive never done it before in Excel so I am just stuck right now€¦

Also, is there a way to display brackets ( ) around a number indicating that
it will be subtracted without making the number negative? Again this is for
an income statement€¦ Thanks