ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   In Excel, when i key in 02352 and press enter, the zero goes off (https://www.excelbanter.com/excel-discussion-misc-queries/263922-excel-when-i-key-02352-press-enter-zero-goes-off.html)

Query

In Excel, when i key in 02352 and press enter, the zero goes off
 
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!

trip_to_tokyo[_3_]

In Excel, when i key in 02352 and press enter, the zero goes off
 
On May 17, 3:11*pm, Query 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.


All times are GMT +1. The time now is 02:33 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com