ExcelBanter - number format

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

- New Users to Excel (https://www.excelbanter.com/new-users-excel/)

- - number format (https://www.excelbanter.com/new-users-excel/183239-number-format.html)

KRK

number format

Hello , I have Excel 2007

Is there a way of getting the number 0 to display as 00 ?

Thanks

K

Ron Rosenfeld

number format

On Thu, 10 Apr 2008 13:01:43 +0100, "KRK"
wrote:

Hello , I have Excel 2007

Is there a way of getting the number 0 to display as 00 ?

Thanks

K

Custom Format Type: 00

or, if you don't want a leading 0 for single digit values, something like:

General;-General;00

--ron

All times are GMT +1. The time now is 03:10 PM.