Default Cell Formats
 

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

Default Cell Formats
 

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.

Alistaire Green wrote:

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

--

Dave Peterson

Default Cell Formats
 

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 !!!!!!

"Alistaire Green" wrote:

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