View Single Post
  #3   Report Post  
Nick Hodge
 
Posts: n/a
Default

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