Thread: IN EXCEL 2003 HOW DO i GET A CELL TO BE 4-0 INSTEAD OF APR00
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Gord Dibben Gord Dibben is offline
external usenet poster
  
Posts: 22,906
Default 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?

Reply With QuoteReply With Quote