0
If you type 00123 into a cell it will become 123. If you want to show the two zeroes, you need to format it as text, with the simplest way being to put a ' in front of it like this: '00123. It will now be a piece of text.
Wiki User
∙ 6y ago
Add your answer:
Earn +20 pts
How you enter account no in Excel sheet it not except?
This question is not clear. You can enter a number in Excel by clicking on a cell and typing the number from the keyboard.
What is a number that can be entered into a cell on Excel?
Which of the following is a number that can be entered into a cell?
How do you enter Euler's number into excel?
=exp(1)
To enter a number such as 6000000000000 000 what other way can I type it in?
You can enter it in Excel as 6E15 (the number has 15 0s. The scientific notation for the number is 6*1015 but to enter that in Excel you have to enter "=" first, and the exponent, 15, is preceded by ^. So the whole string that you need to enter is "=6*10^15"
In excel to enter a number as text start the entry with a?
apostrophe
How do you '0' can insert before a numerical number in Microsoft Excel?
type '05 instead of 05 the ' tells excel that you want to enter a text, not a number Proud to be of service HoloGuides.com
How to calculate the percentage change between two numbers in excel?
Enter 1st number in A1 Enter 2nd number in A2 In A3 enter =(1-A2/A1)*100 Or you can enter in A3 =(1-A2/A1) and format cell as number percentage
How many centiliters are in 12.3 hectoliters?
.00123
How many milliliters are you 1.23 meters?
.00123 millimeters
How you write in Microsoft Excel to make a number in cell A1 10 percent smaller than the number in D4 you enter?
=d4%10
What allows you to enter a number once in excel and enter it in the same cell on all selected worksheets?
The process you are referring to is called "drilling an entry". Hope this helps :)
To enter a number such as 6000000000000000 you can type 6000000000000000 or you can type what?
6000000000000000 or =6*10^15In Excel it would be 6E15
