Cell Formatting

  • Thread starter Thread starter Carey
  • Start date Start date
C

Carey

Hi,

I have a client who is trying to use Negative numbers in
cells. When the regional settings on her PC are set to
English (US) she has the option of both using -1.1 or
(1.1) as the format for the cells.

But when we switch to English (Canada) the only option she
has is (1.1).

I have tried to replicate the issue myself on my own
machine with the same regional settings but when I switch
to canada, I am still able to format as -1.1 or (1.1).

Is this a bug in excel or am I missing something? She
wants to be able to have currency with a "-" option but it
not available.

Any help is appreciated.
 
I don't know what the problem is but if she uses General format it will
return -1.1 or
use a custom format 0.00
 
Back
Top