IN EXCEL 2003 HOW DO i GET A CELL TO BE 4-0 INSTEAD OF APR00
 

I am setting up an inventory sheet and everytime I try to enter 4-0 under
size it comes up APR 00 and when I do 5-0, I get May00. How do I change the
column so it allows 4-0 or 0-0?

IN EXCEL 2003 HOW DO i GET A CELL TO BE 4-0 INSTEAD OF APR00
 

Pre-format the cells as Text or preface the 4-0 with an apostrophe which won't
be visible.


Gord Dibben MS Excel MVP

On Wed, 1 Nov 2006 16:34:02 -0800, TWMMAM
wrote:

I am setting up an inventory sheet and everytime I try to enter 4-0 under
size it comes up APR 00 and when I do 5-0, I get May00. How do I change the
column so it allows 4-0 or 0-0?

IN EXCEL 2003 HOW DO i GET A CELL TO BE 4-0 INSTEAD OF APR00
 

Gord Dibben wrote:
Pre-format the cells as Text or preface the 4-0 with an apostrophe which won't
be visible.


Gord Dibben MS Excel MVP

On Wed, 1 Nov 2006 16:34:02 -0800, TWMMAM
wrote:

I am setting up an inventory sheet and everytime I try to enter 4-0 under
size it comes up APR 00 and when I do 5-0, I get May00. How do I change the
column so it allows 4-0 or 0-0?




Hi Gord,
Not sure what you are using the data for - but to change the format of
this one you need to right click on the cell and go to FORMAT
CELLS/NUMBER. Scroll to the bottom where it says CUSTOM. On the right
hand side of the FORMAT CELL box in TYPE: enter m-h. That will change
APR00 to 4-0.

Hope this helps.

Have a great day!
Jenni

IN EXCEL 2003 HOW DO i GET A CELL TO BE 4-0 INSTEAD OF APR00
 

Thanks Jenn

Please respond to original poster(TWMMAM), not to me.


Gord

On 6 Nov 2006 15:55:10 -0800, "Jenn" wrote:


Gord Dibben wrote:
Pre-format the cells as Text or preface the 4-0 with an apostrophe which won't
be visible.


Gord Dibben MS Excel MVP

On Wed, 1 Nov 2006 16:34:02 -0800, TWMMAM
wrote:

I am setting up an inventory sheet and everytime I try to enter 4-0 under
size it comes up APR 00 and when I do 5-0, I get May00. How do I change the
column so it allows 4-0 or 0-0?




Hi Gord,
Not sure what you are using the data for - but to change the format of
this one you need to right click on the cell and go to FORMAT
CELLS/NUMBER. Scroll to the bottom where it says CUSTOM. On the right
hand side of the FORMAT CELL box in TYPE: enter m-h. That will change
APR00 to 4-0.

Hope this helps.

Have a great day!
Jenni

IN EXCEL 2003 HOW DO i GET A CELL TO BE 4-0 INSTEAD OF APR00
 

Gord,
So sorry - I did not see the original post. On my side, this appears
as a new thread started by you.

Sorry again..just trying to help.
Jenni


Gord Dibben wrote:
Thanks Jenn

Please respond to original poster(TWMMAM), not to me.


Gord

On 6 Nov 2006 15:55:10 -0800, "Jenn" wrote:


Gord Dibben wrote:
Pre-format the cells as Text or preface the 4-0 with an apostrophe which won't
be visible.


Gord Dibben MS Excel MVP

On Wed, 1 Nov 2006 16:34:02 -0800, TWMMAM
wrote:

I am setting up an inventory sheet and everytime I try to enter 4-0 under
size it comes up APR 00 and when I do 5-0, I get May00. How do I change the
column so it allows 4-0 or 0-0?




Hi Gord,
Not sure what you are using the data for - but to change the format of
this one you need to right click on the cell and go to FORMAT
CELLS/NUMBER. Scroll to the bottom where it says CUSTOM. On the right
hand side of the FORMAT CELL box in TYPE: enter m-h. That will change
APR00 to 4-0.

Hope this helps.

Have a great day!
Jenni