Re: Number formats inconsistent

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

I don't use Citrix, but maybe...

Excel picks this up from 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.

Jack Sheet wrote:

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

--

Dave Peterson
.

Relevant Pages

  • Re: Number formats inconsistent
    ... I don't speak Citrix and don't have another guess. ... International Settings on the server, ... change the negative currency format to show 's. ... Dave Peterson ...
    (microsoft.public.excel.setup)
  • Re: leading zeroes on report date
    ... Open the Windows Control Panel. ... To set the Format property of the text box on your report in Access: ... reset a windows regional setting to make short date ... > I don't know how to find or set windows regional settings. ...
    (microsoft.public.access.formscoding)
  • Re: Excel 2000 Header Date Format..
    ... I set my Windows short date settings this way: ... Control Panel, Regional and Language Options, Regional Options tab, Short date: ... I can't figure out what to change to get the proper date format. ... I'm using Windows XP home edition SP3. ...
    (microsoft.public.excel)
  • Re: formatting of row depending on cell value
    ... Depends upon your short date format in Windows settings. ... Gord Dibben  MS Excel MVP ...
    (microsoft.public.excel.newusers)
  • Re: Adaptec AHA-2940AU vs AHA-1530P
    ... 1/ Under windows, run the device manager and look for the scsi drive. ... settings and verify that the "init 13 unit" option is turned on. ... 2/ Drop into a DOS box and run Fdisk from there. ... reboot into windows and format using "My computer" ...
    (comp.periphs.scsi)