Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.setup
|
|||
|
|||
![]()
We run Office 2003 on a Citrix terminal server. Having just migrated from
one server to another (version 9.230.50211) we now encounter this problem: Most of our spreadsheets were configured to display negative numbers in brackets, via Format/Cells/Number tab/Number, then third selection down. If you open the file outside of Citrix and select a cell that has been thus formatted, and click on Format/Cell then the display highlights that selection. If you then click on custom format it displays #,##0.00_);[Red](#,##0.00) If you close (without saving) and re-open the same file within Citrix, select the same cell as above, and view the format settings, it goes straight to Custom selection (not "Number") selection and displays #,##0.00;[Red]-#,##0.00 We tried changing the international settings on the server (stored outside Excel, part of the Windows OS settings) so that negative numbers be displayed in brackets by default, but it did not seem to help. Anyone got any other ideas? Is this a regular problem? Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Number Formats | Excel Discussion (Misc queries) | |||
Migrating Excel Data with inconsistent formats | Excel Discussion (Misc queries) | |||
number formats | Excel Worksheet Functions | |||
Custom Number Formats | Excel Worksheet Functions | |||
Phone Number Formats | Excel Discussion (Misc queries) |