Default cell format for excel workbook is ‘General’. This post will help you modify this format with the cell format you want.
My earlier post spoke about creating number format that displays the negative symbol on right side of the number (refer post: Custom Number format – How to display a negative sign on the right side of the number?).
read: http://msofficetuts.blogspot.com #pdf