Excel cell formatting

microsoft excel

I want to insert numbers in an Excel cell (ex. 01-00), but the formatting wants it to default to a date (ex. Jan-1). How do I delete this formating so I can enter simple numbers?

Best Answer

  • There are two possible ways:

    1) format your cells as text before input

    2) use an apostrophe to precede the entry, e.g. enter '01-00 - the apostrophe tells excel that the entry is to be treated as text - it isn't displayed