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?
Excel cell formatting
microsoft excel
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