View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
The Rudster The Rudster is offline
external usenet poster
 
Posts: 2
Default Removing leading zero from cent amounts

I am receiving a zero in front of the decimal point when I enter a cent
amount,e.g.,
0.50 when I want .50 in the cell. I am using Microsoft Excel 2000. I want to
prevent this from happening.