Excel

J

Janet

I wish to type a series of numbers in a column, such as
invoice numbers example: 3-1900, 3-1901 etc. However,
whenver I do this, I get the date Mar-00. Any advice?
 
E

Ed

You can try either formatting the cells as text before you enter your data,
or preceed your data with an apostrophe (as in '3-1900).

Ed
 
K

kiki

-----Original Message-----
I wish to type a series of numbers in a column, such as
invoice numbers example: 3-1900, 3-1901 etc. However,
whenver I do this, I get the date Mar-00. Any advice?
.
Janet,
Go to Formatting, Cells and change your cell format to a
general one instead of the date selection you are getting.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top