Prev: Calculate Holiday
Next: How do I align numbers in different cells when some are in bracke.
From: Query on 17 May 2010 09:11
In Excel, when i key in any group of numbers with a zero preceding it, and
then press enter, the zero disappears. How do i for instance key in 02352.
with the zero still intact when i press enter. Please help!
From: trip_to_tokyo on 17 May 2010 09:19
On May 17, 3:11 pm, Query <Qu...(a)discussions.microsoft.com> wrote:
> In Excel, when i key in any group of numbers with a zero preceding it, and
> then press enter, the zero disappears.  How do i for instance key in 02352.
> with the zero still intact when i press enter.  Please help!

EXCEL 2007

Format the cell(s) as text (Home / Font group / click on arrow in
lower right hand corner / Format Cells should launch / Number tab /
Text / OK).

If my comments have helped please hit Yes.

Thanks.
 | 
Pages: 1
Prev: Calculate Holiday
Next: How do I align numbers in different cells when some are in bracke.