| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Selection won't move when I press enter...do you know why? | Excel Discussion (Misc queries) | |||
| Macro to select cells in column enter data then press enter | New Users to Excel | |||
| excel press enter to make active on 1st colum in new row | New Users to Excel | |||
| Is there a way to skip over fields when I press the ENTER key? | Excel Discussion (Misc queries) | |||
| When I Press the Enter Key Nothing happens. | Excel Discussion (Misc queries) | |||
Linear Mode
