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 ?

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 ?

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 ?

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

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 ?

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 ?

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

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