Thread: HELP......
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Peo Sjoblom Peo Sjoblom is offline
external usenet poster
 
Posts: 3,268
Default HELP......

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