ExcelBanter - How do I show zeros?

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

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

- - How do I show zeros? (https://www.excelbanter.com/excel-discussion-misc-queries/135592-how-do-i-show-zeros.html)

J.D.

How do I show zeros?

I need to show some numbered codes on my spreadsheet. But everytime I type
the codes with zeros in the beginning Excel deletes the zeros. So...

0051200
ends up being
51200

How do I stop this?

J.D.[_2_]

How do I show zeros?

nevermind I figured it out.

"J.D." wrote:

I need to show some numbered codes on my spreadsheet. But everytime I type
the codes with zeros in the beginning Excel deletes the zeros. So...

0051200
ends up being
51200

How do I stop this?

Gord Dibben

How do I show zeros?

One of these three methods...............

Pre-format the cells as Text.

Type and apostrophe then your number.

Custom Format as 0000000

Gord Dibben MS Excel MVP

On Tue, 20 Mar 2007 09:22:34 -0700, J.D. wrote:

I need to show some numbered codes on my spreadsheet. But everytime I type
the codes with zeros in the beginning Excel deletes the zeros. So...

0051200
ends up being
51200

How do I stop this?

All times are GMT +1. The time now is 03:51 AM.