Question:

I am trying to make an excel spreadsheet,but when i try typing a # in the cell, it makes it a month and date?

by  |  earlier

0 LIKES UnLike

how can i type something in (like 11-8013) with out it converting it into Nov-8013??? Thanks!

 Tags:

   Report
Answer The Question I've Same Question Too

5 ANSWERS

Sort By: Date  |  Rating

  1. Go to Insert. Select Symbol. Go to the subset basic latin. Select the # sign and press insert.


  2. Hi Meagan,

    There are lot of ways to that..

    1. Before typing change the format of the cell to text and type 11-8013

    2. Type '11-8013

    Hope this helps...

    Cheers!

    Guru

  3. type '11-8013

  4. If you begin with an apostrophe, the cell is recognized as text and so, '11-8013 will show as 11-8013.

  5. Right click on the cell, go to Format Cells.  Choose the Number tab, should already be on it, and select Text.  Then just choose OK.  Then you can type whatever you want and it will leave it that way.
You're reading: I am trying to make an excel spreadsheet,but when i try typing a # in the cell, it makes it a month and date?

Question Stats

Latest activity: earlier.
This question has 5 answers.

BECOME A GUIDE

Share your knowledge and help people by answering questions.
Register Now