View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Homer
 
Posts: n/a
Default how do i format cells with preceeding zeros & minus sign

Hi

I am downloading data in to excel & need to format an amount field in to a
fixed 12 character field i.e. prefix with zeros to fill the 12 chars. NOW
comes the tricky bit, if the value is negative I need the (-) minus sign
prior to any leading zeros.

Help Please!