How to insert number as number in excel
Asked By
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..
Best Answer
Best Answer
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.
Â
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.
Latest Articles
Top Construction Management Apps
Construction management is essential to ensure project completion in a timely and cost-effective manner. Construction management software support businesses to operate efficiently. The software is available for all types of construction projects, including residential...
Best Mirrorless Cameras
Mirrorless camera is the latest obsession among the photographers. The cameras have altogether replaced the traditional DSLR models with their unique and special features.
A mirrorless camera is a light-weighted electronic device device that utilizes...
Improve Your Manuscript Before Publishing: Eight Ways To Help
Every author expects to experience a sense of achievement unlike any other when they complete their manuscript. However, some authors agree that they do not feel fully satisfied looking back at the achievement that...
Latest Blogs
Top 10 New Laptop Entrants That Shook The Public
The finest laptops are powerful enough to do your daily tasks, comfortable enough to use all day, and power-efficient enough to ensure you don't run out of battery power unexpectedly. Of course, all these...
10 Facts About The Dark Web
Before getting into knowing the facts, let’s have a brief about the Dark Web. The dark web is the data of the World Wide Web that is accessible only through special software, combinations, or...
Top 10 Latest Steam Cleaner Machines
While looking for a chemical-free way to clear and purify both durable and low grounds in your home, a steam cleaner is an excellent solution. With a spurt of superheated steam, this cleaning equipment...
Latest Tips
Top 10 Internet Monitoring Software
Internet monitoring software keeps a log of all internet activities. You can install this type of software on your computer remotely or by the administrator. An operating console controls this software. This type of...
Top 10 Best Partition Manager Software
A Hard Disk Drive is usually partitioned into various smaller drives for optimization. A partition manager helps make this process easier and more efficient. Here, let’s discuss the top 10 best partition manager software.
1....
Top 10 Best Online Music Production Software
Music production is the initial stage of any song. Music production can be done either in studios or at home using an online music production software. Here, let’s discuss the top 10 best online...
