View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Zecarioca Zecarioca is offline
external usenet poster
 
Posts: 3
Default Formatting Question

How can I change the default setting for cell formatting - even on existing
spreadsheets. I wanted all numbers to be inputed as currency with 0 decimal
places, but it always defaults to numbers with 2 decimal places. I know I
can change the formatting after the fact, but I wanted this to be the default
setting.

Thanks for any help.