Zeros on the left

[Khalil handal]

Hi,
have check number such as 00356. When entered in a cell and pressing enter,
it shows 356.
How can we keep it shown as 00356? and what cell format is necessary if any?

 

[GerryGerry]

custom format to '00000' (without he single quotes)

 

[Khalil handal]

Thnaks.
It worked fine

custom format to '00000' (without he single quotes)

 

[CLR]

Another way is to simply type an apostrophe before typing the leading zero.
This converts the cell to TEXT format and the zero's show.

Vaya con Dios,
Chuck, CABGx3

 

[GerryGerry]

Formating as text will stop you being able to do mathematical calculations
on that cell

 

[CLR]

That's true, however, mathematical calculations are rarely done on "Check
numbers".

Also, with the "Formatting method", the leading zero's would be lost during
a "Copy > PasteSpecial > Values" procedure.

Vaya con Dios,
Chuck, CABGx3

 

[macropod]

No, it just makes it more complicated.

For example, if you've got a 'text' number in A1, then =VALUE(A1) will retrieve the numerical value and, if you've got such values
in A1:A3, then =SUM(VALUE(A1:A3)) entered as an array formula will sum the values.

Cheers