| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can can I enter 023023 in a cell without losing the first 0
Hi, does anybody know how I can enter the number 023023 in a cell without
automatically losing the first zero ? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How can can I enter 023023 in a cell without losing the first 0
Put a ' in front or format the cell as text
Mike "Frustrated" wrote: Hi, does anybody know how I can enter the number 023023 in a cell without automatically losing the first zero ? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How can can I enter 023023 in a cell without losing the first
Yes, that will work, but I understand the askers concern. Is there a way to
retain the beginning '0' and keep the cell in number format? There are MANY reasons (at least for myself) that I need to be able to keep it in number format. Yes, the leading '0' is absolutely necessary for me to retain. "Mike H" wrote: Put a ' in front or format the cell as text Mike "Frustrated" wrote: Hi, does anybody know how I can enter the number 023023 in a cell without automatically losing the first zero ? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How can can I enter 023023 in a cell without losing the first 0
On Mon, 15 Oct 2007 04:14:02 -0700, Frustrated
wrote: Hi, does anybody know how I can enter the number 023023 in a cell without automatically losing the first zero ? Format the cell: Format/Cells/Number/Custom Type: 000000 --ron |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How can can I enter 023023 in a cell without losing the first
What are a couple of the many things you want to do that you can't do using
this solution? "Ean Wilson" wrote: Yes, that will work, but I understand the askers concern. Is there a way to retain the beginning '0' and keep the cell in number format? There are MANY reasons (at least for myself) that I need to be able to keep it in number format. Yes, the leading '0' is absolutely necessary for me to retain. "Mike H" wrote: Put a ' in front or format the cell as text Mike "Frustrated" wrote: Hi, does anybody know how I can enter the number 023023 in a cell without automatically losing the first zero ? |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How can can I enter 023023 in a cell without losing the first
Format the cell as 000000
-- David Biddulph "Ean Wilson" wrote in message ... Yes, that will work, but I understand the askers concern. Is there a way to retain the beginning '0' and keep the cell in number format? There are MANY reasons (at least for myself) that I need to be able to keep it in number format. Yes, the leading '0' is absolutely necessary for me to retain. "Mike H" wrote: Put a ' in front or format the cell as text Mike "Frustrated" wrote: Hi, does anybody know how I can enter the number 023023 in a cell without automatically losing the first zero ? |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How can can I enter 023023 in a cell without losing the first
Works for me! Thanks. :)
"Ron Rosenfeld" wrote: On Mon, 15 Oct 2007 04:14:02 -0700, Frustrated wrote: Hi, does anybody know how I can enter the number 023023 in a cell without automatically losing the first zero ? Format the cell: Format/Cells/Number/Custom Type: 000000 --ron |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How can can I enter 023023 in a cell without losing the first
On Mon, 15 Oct 2007 05:07:00 -0700, Ean Wilson
wrote: Works for me! Thanks. :) "Ron Rosenfeld" wrote: On Mon, 15 Oct 2007 04:14:02 -0700, Frustrated wrote: Hi, does anybody know how I can enter the number 023023 in a cell without automatically losing the first zero ? Format the cell: Format/Cells/Number/Custom Type: 000000 --ron You're welcome. Thanks for the feedback. --ron |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Enter multiple numbers in a cell so total shows when enter keypres | Excel Worksheet Functions | |||
| Auto enter date when data in enter in another cell | Excel Worksheet Functions | |||
| Losing Cell Protection When Saving Workbook | Excel Discussion (Misc queries) | |||
| enter formula into Excel worksheet without losing numbers | Excel Discussion (Misc queries) | |||
| how do I enter a RETURN (Enter) in a cell in EXCEL2003 | Excel Discussion (Misc queries) | |||
Linear Mode
