format negative dollars

  • Thread starter Thread starter doug loewen
  • Start date Start date
D

doug loewen

We have 2 computers in this office, both with Office XP
On one we get ($ 4.00) on the other we get -$ 4.00 This
format seems to vary from file to files. Is there a way
to set the default on Excel to ($ 4.00) ?
Thanks
Doug
 
Doug,

It might help to check the Regional Settings in the
Control Panel (I assume your using windows). It
has settings for currency and number displays
which will affect excel. Check if yours and your
co-workers settings are the same.

Dan E
 
Back
Top