microsoft excel 2007

B

Ben

how are you able to stop the '0's disapearing, for example if i put in 02 or
2.0 both the 'o's are removed or simplefied,
 
G

Gord Dibben

To prevent leading zeros from disappearing, preface with an apostrophe or Custom
format to 00

Format to 1 or more decimal places.


Gord Dibben MS Excel MVP
 
Top