Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Brackets on one PC but not another in Excel 2003?
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Brackets on one PC but not another in Excel 2003?
Make sure you are using the same printer with the same settings.
"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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Brackets on one PC but not another in Excel 2003?
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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Brackets on one PC but not another in Excel 2003?
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 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Brackets on one PC but not another in Excel 2003?
I was trying to avoid doing that as it is a large number spreadsheets. I had
hoped that since it was showing up correctly on one PC we could get it to replicate easily on the others. Thanks again. "Dave Peterson" wrote: 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 |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Brackets on one PC but not another in Excel 2003?
You may want to share the custom format that didn't work and what you typed into
the cell. Maybe someone will have a better idea. Maybe you could create your own style (format|style) and give each cell that contains the footnote that style. Chopsx7 wrote: I was trying to avoid doing that as it is a large number spreadsheets. I had hoped that since it was showing up correctly on one PC we could get it to replicate easily on the others. Thanks again. "Dave Peterson" wrote: 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 -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
excel 2003 no brackets in number format | Setting up and Configuration of Excel | |||
Label brackets switched around in 2003 | Charts and Charting in Excel | |||
In excel 2003, the negative numbers not appearing with brackets | New Users to Excel | |||
converted square brackets in worksheet name excel 2003 | Excel Discussion (Misc queries) | |||
brackets { } in excel formulas | Excel Worksheet Functions |