I'm not sure why the custom format didn't work, but...

You could enter the footnote as text.

Either PRE-format the cell as text, then type the value.

Or start with a leading apostrophe: '(1)

But just changing the format from General to Text won't help. You still have to
make excel think you made a change to the value.

Chopsx7 wrote:

Thanks, but there are other numbers within the spreadsheet that are negative
that show up with brackets.

"Dave Peterson" wrote:

My guess is that you're entering negative numbers by using (4)

If you want the ()'s to show up for negative numbers in the format|cells|number
tab, you'll have to change a windows setting.

Windows start button|control panel
regional and language options
regional options tab
click the customize button
currency tab
change the negative currency format to show ()'s.



Chopsx7 wrote:

I have a spreadsheet that contains some footnotes. The footnotes are
bracketed. i.e (1)(4). We have a LAN. When one PC opens the file the
brackets are visible and appear on the printed hardcopy. When any other PC
opens the same file there are no brackets nor are they there when it is
printed. The settings (at least the basic ones) seem to be the same on both
PCs as is the excel version. We tried changing the cell formatting to text
(it was a custom format before) on the PC where the brackets appeared and
re-saving it. However when we opened the resaved file on any other PC the
brackets were still not appearing. All other formatting appears to be
identical? Does anybody know why the brackets would be surpressed on the
other PCs?? Thanks

--

Dave Peterson


--

Dave Peterson