Noobie question

Lmo

New Member
Joined
Sep 25, 2006
Messages
2
Help! I am trying to create a spreadsheet and have defined columns. When I start to put my data in, I type in something like 11-3210 for a department number, and what appears in the column is a date...Nov-10. For some reason it is assuming that I mean for the info to be a date, when in fact, I dont.

Another example is when I put a serial number in another column- I put in 100557349340. What appears in the colum is: 1.00557E+11.
I am assuming this is some kind of formatting thing that is substituting the numbers that I put in for all of this other stuff. Is there a setting that needs to be changed? Thanks for your help!
 

Some videos you may like

Excel Facts

Save Often
If you start asking yourself if now is a good time to save your Excel workbook, the answer is Yes

VoG

Legend
Joined
Jun 19, 2002
Messages
63,650
Try selecting the cells that you are going to be entering data in and Format > Cells and set as Text.
 

Lmo

New Member
Joined
Sep 25, 2006
Messages
2
Thank you ever so kindly! Actually, formatting as 'special' was the resolution, but you had me in the right place!
Thank you again! :biggrin:
 

orysiar

New Member
Joined
Sep 14, 2006
Messages
13
Noobie Question

Or, just put an apostrophe in front of the numbers - it will not show in the contents of the cell i.e. '11-3210 will show as 11-3210 on the excel spreadsheet - no special formatting of cell necessary
 

Watch MrExcel Video

Forum statistics

Threads
1,113,795
Messages
5,544,332
Members
410,603
Latest member
rseckler
Top