ExcelBanter - microsoft excel 2007

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - microsoft excel 2007 (https://www.excelbanter.com/excel-discussion-misc-queries/182602-microsoft-excel-2007-a.html)

Ben

microsoft excel 2007

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,

Gord Dibben

microsoft excel 2007

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,

All times are GMT +1. The time now is 04:56 AM.