Removing leading zero from cent amounts
Select the cell(s) and Format|Cells|Custom:
type: .00
The Rudster wrote:
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.
--
Dave Peterson
|