Default Cell Formats

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is there anyway possible to change the default layout of an excel spreadheet
in the way of how it shows a negative value, eg as the minute when you choose
the cell to be a currency it shows up as - £800 in red, but id like it to
change it to (£800) instead.

At the minute i have to change it within the custom settings but surely
there is a of changing it?

Any Ideas
 
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.
 
Thanks, the answer is always looking at you, cannot beleive i did'nt know
that! ill just put it down to been a monday morning !!!!!!
 
Back
Top