Excel Decimals

yethela · Sep 30, 2003

Does anyone know how to have .50 be displayed as it is on an excel
worksheet without the 0 before the decimal???

Chip Pearson · Oct 1, 2003

A custom number format of #.00 will do this.

CLR · Oct 1, 2003

Right-click on the cell > Format cells > Number tab > Custom > type .00 in
the Type: window > ok

Vaya con Dios,
Chuck, CABGx3