Zeros on the left

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Khalil handal - 11 Dec 2007 10:24 GMT

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?

Reply to this Message

GerryGerry - 11 Dec 2007 10:50 GMT

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

> 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?

Reply to this Message

Khalil handal - 11 Dec 2007 12:31 GMT

Thnaks.
It worked fine

> custom format to '00000' (without he single quotes)
>
[quoted text clipped - 3 lines]
>> How can we keep it shown as 00356? and what cell format is necessary if
>> any?

Reply to this Message

CLR - 11 Dec 2007 12:57 GMT

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

> 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?

Reply to this Message

GerryGerry - 11 Dec 2007 13:07 GMT

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

> Another way is to simply type an apostrophe before typing the leading
> zero.
[quoted text clipped - 9 lines]
>> How can we keep it shown as 00356? and what cell format is necessary if
>> any?

Reply to this Message

CLR - 11 Dec 2007 13:19 GMT

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

> Formating as text will stop you being able to do mathematical calculations
> on that cell
[quoted text clipped - 11 lines]
> >> How can we keep it shown as 00356? and what cell format is necessary if
> >> any?

Reply to this Message

macropod - 11 Dec 2007 20:54 GMT

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

Signature

macropod
[MVP - Microsoft Word]
-------------------------

> Formating as text will stop you being able to do mathematical calculations on that cell
>> Another way is to simply type an apostrophe before typing the leading zero.
[quoted text clipped - 7 lines]
>>> it shows 356.
>>> How can we keep it shown as 00356? and what cell format is necessary if any?

Reply to this Message

Rate this thread: