| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2003, when I click on a particular cell it gets deselected | New Users to Excel | |||
| How to set number of characters within a cell in Excel 2003? | Excel Worksheet Functions | |||
| Cell shading issue on EXCEL 2003 | Excel Discussion (Misc queries) | |||
| How do I get top cell alignment in excel 2003 | Excel Discussion (Misc queries) | |||
| GET.CELL | Excel Worksheet Functions | |||
Hybrid Mode
