Zeros on the left

  • Thread starter Thread starter Khalil handal
  • Start date Start date
K

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?
 
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
 
Formating as text will stop you being able to do mathematical calculations
on that cell
 
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
 
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
 
Back
Top