View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default Brackets on one PC but not another in Excel 2003?

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