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
On Fri, 4 Apr 2008 18:48:06 -0700, Ben wrote:

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,