How to insert number as number in excel

Asked By valentino 0 points N/A Posted on - 10/09/2011

hello, I have a problem use excel 2003.

when i type a number e.g 3/4, it typed as a date in cell.

what step should do to solve my problem,

thanks..

• Status: Open
• Question Views: 1129
• Answer Count: 2
• Vote Up 0 Vote Down

• Answer Accepted: Yes
• Question Category: MS Excel

Best Answer by Peter123

Go To Solution

Best Answer

Best Answer

Answered By Peter123 0 points N/A #90249

How to insert number as number in excel

Hi!

Nevertheless, MS Excel provides a tremendous range of functions available to make our spreadsheets more readable for showing various types of data. The problem you are facing is not actually a problem rather it is a functionality of Excel that we can project our data in various forms. Fractions like 33/4 are generally treated as dates however, if you want it to be shown just as you typed you must follow this procedure.

Select the cell you want to format as required.

Select Format menu select font then select numbers here you can select various data forms like general, data, time, currency and even text.

Select Text as your required format.

Now the data will be treated as text and will be displayed just as it is typed.

Hope it helps.

 

About Peter123

Questions
0

Answers
27

Best Answers
9

• Vote Up 0 Vote Down

• Posted on - 10/09/2011
• Question Category: MS Excel

Answered By joseph21 0 points N/A #90250

How to insert number as number in excel

Hi Valentino,

The moment you type any number such as 2/3 in a cell, normally excel will convert it into a date. So if you really want to type a fraction in excel spreadsheet;

First select the cell or a number of cells you need to format.

Go to the format menu and click on cells.

In the category list on the number tab click on fraction.

Then click the fraction format to apply from the type list.

After that, any numbers you type in that cell, will be displayed as fractions.

OR

In case you not going to do calculations, you can format the cell as text, after you do this, any fraction you type in such a cell will not be converted to decimals or date. to do this, in the format menu click on cells command and then number type.

The above ways will definitely help you to solve your problem.

About joseph21

Questions
0

Answers
5

Best Answers
3

• Vote Up 0 Vote Down

• Posted on - 10/09/2011
• Question Category: MS Excel