Mazza
If you want to make a permanent change you can do that via control panel in
windows in regional settings
For a workbook level change you can use a format
(FormatCells...NumberCustom), like so.
0.00;(0.00);0
Check here for some help on this
http://www.nickhodge.co.uk/gui/forma...htm#number_tab
--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
HIS
"mazza" wrote in message
...