Home » Category » Microsoft Excel

Microsoft Excel: Zeros on the left

205| Thu, 22 May 2008 03:53:00 GMT| anonymous| Comments (6)
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?

Keywords & Tags: zeros, left, microsoft, excel

URL: http://developertags.com/microsoft-excel/495048/
 
«« Prev - Next »» 6 helpful answers below.
custom format to '00000' (without he single quotes)

"Khalil handal" <khhandal...yahoo.com> wrote in message
news:e6CjzA%23OIHA.4480...TK2MSFTNGP06.phx.gbl...
> 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 | Thu, 22 May 2008 03:55:00 GMT |

Thnaks.
It worked fine

"GerryGerry" <Gerry...Gerry.anon> wrote in message
news:kYt7j.28891$kt3.16939...fe3.news.blueyonder.co.uk...
> custom format to '00000' (without he single quotes)
> "Khalil handal" <khhandal...yahoo.com> wrote in message
> news:e6CjzA%23OIHA.4480...TK2MSFTNGP06.phx.gbl...
>> 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?
>>
>

khalil | Thu, 22 May 2008 03:56:00 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

"Khalil handal" wrote:

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

clr | Thu, 22 May 2008 03:57:00 GMT |

Formating as text will stop you being able to do mathematical calculations
on that cell
"CLR" <CLR...discussions.microsoft.com> wrote in message
news:71D35B5D-BABB-44A1-8230-5F9F68DB9DAF...microsoft.com...
> 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
>
> "Khalil handal" wrote:
>> 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 | Thu, 22 May 2008 03:58:00 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

"GerryGerry" wrote:

> Formating as text will stop you being able to do mathematical calculations
> on that cell
> "CLR" <CLR...discussions.microsoft.com> wrote in message
> news:71D35B5D-BABB-44A1-8230-5F9F68DB9DAF...microsoft.com...
> > 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
> >
> >
> >
> > "Khalil handal" wrote:
> >
> >> 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?
> >>
> >>
> >>
>
>

clr | Thu, 22 May 2008 03:59:00 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
--
macropod
[MVP - Microsoft Word]
--

"GerryGerry" <Gerry...Gerry.anon> wrote in message news:bYv7j.29261$kt3.168...fe3.news.blueyonder.co.uk...
> Formating as text will stop you being able to do mathematical calculations on that cell
> "CLR" <CLR...discussions.microsoft.com> wrote in message news:71D35B5D-BABB-44A1-8230-5F9F68DB9DAF...microsoft.com...
>> 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
>>
>> "Khalil handal" wrote:
>> 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?
>>
>

macropod | Thu, 22 May 2008 04:00:00 GMT |

Microsoft Excel Hot Answers

Microsoft Excel New questions

Microsoft Excel Related Categories