answersLogoWhite

0

Start the entry with an apostrophe or format the cell as text.

User Avatar

Wiki User

14y ago

What else can I help you with?

Related Questions

When you enter a date excel assigns a what value to the date?

numerical


Can you put fifteen digits in excel?

Yes you can enter a number as text in which case you can enter I believe up to 256 digits. or you can enter 15 single digits numbers into 15 different cells or you can enter a single 15 digit number in a single cell (this is the physical limit set by the software on how many digits a number can be allowed to have) though it will most likely be displayed in scientific notation unless you format it differently.


What is the security measure that requires you to enter the last 4 digits of your debit card?

The security measure that requires you to enter the last 4 digits of your debit card is called card verification.


How many significant digits are in this number Type the correct answer then press Enter. 50.00?

Four significant digits in 50.00.


The pmosc enter pmos code in five seven or nine digits?

true


How do you represent data as a series of numerical values?

You can assign a numerical value to each element in your data series. There are several ways to do that. Here is a simple example:In cell A1 enter your first data element. Let that entry be GREEN.In cell B1 enter the formula, =IF(A1="GREEN",1,0). Observe that the value of B1 is 1, since the contents of cell A1 is GREEN. If A1 = RED, then B1 would display 0.You also could give a value to each data item depending on the number of characters in the cell. You can do this with the formula =LEN(A1).


In Excel to enter number or test place what before the number?

If you just want to enter a number into a cell, you do not need to type anything before it. If you want to type in digits that do not maintain their numeric value or a number that you want to include a zero at the start of it, like a code number or phone number, you enter the single quote before it, which leads it to being treated like a piece of text, not a value, like this: '0258818 If you are typing in a formula, you put the equals sign before it, otherwise it will be treated like text and not a calculation.


How do you unlock mynew Verizon blitz utstarcom phone?

enter the last four digits of your cell phone number


How many digits can you enter for the pmosc on the ncoer?

PMOSC is up to 9 digits. First 3 digits= MOS 4th digit= Skill level (based on rank) 6th&7th digits= ASI 8th&9th= Language (if applicable) example- 12B3S5WQB


How do you calculate the numerical aperture for a given optical system?

To calculate the numerical aperture for an optical system, you can use the formula: Numerical Aperture n sin(), where n is the refractive index of the medium between the lens and the specimen, and is the half-angle of the maximum cone of light that can enter the lens.


How does Excel recognize a year when only two digits are entered?

It depends on the two digits entered. Anything from 00 to 29 is taken as being the years 2000 to 2029. Anything from 30 to 99 is taken as being as being 1930 to 1999. You need to enter 4 digits if the year is outside of these ranges.It depends on the two digits entered. Anything from 00 to 29 is taken as being the years 2000 to 2029. Anything from 30 to 99 is taken as being as being 1930 to 1999. You need to enter 4 digits if the year is outside of these ranges.It depends on the two digits entered. Anything from 00 to 29 is taken as being the years 2000 to 2029. Anything from 30 to 99 is taken as being as being 1930 to 1999. You need to enter 4 digits if the year is outside of these ranges.It depends on the two digits entered. Anything from 00 to 29 is taken as being the years 2000 to 2029. Anything from 30 to 99 is taken as being as being 1930 to 1999. You need to enter 4 digits if the year is outside of these ranges.It depends on the two digits entered. Anything from 00 to 29 is taken as being the years 2000 to 2029. Anything from 30 to 99 is taken as being as being 1930 to 1999. You need to enter 4 digits if the year is outside of these ranges.It depends on the two digits entered. Anything from 00 to 29 is taken as being the years 2000 to 2029. Anything from 30 to 99 is taken as being as being 1930 to 1999. You need to enter 4 digits if the year is outside of these ranges.It depends on the two digits entered. Anything from 00 to 29 is taken as being the years 2000 to 2029. Anything from 30 to 99 is taken as being as being 1930 to 1999. You need to enter 4 digits if the year is outside of these ranges.It depends on the two digits entered. Anything from 00 to 29 is taken as being the years 2000 to 2029. Anything from 30 to 99 is taken as being as being 1930 to 1999. You need to enter 4 digits if the year is outside of these ranges.It depends on the two digits entered. Anything from 00 to 29 is taken as being the years 2000 to 2029. Anything from 30 to 99 is taken as being as being 1930 to 1999. You need to enter 4 digits if the year is outside of these ranges.It depends on the two digits entered. Anything from 00 to 29 is taken as being the years 2000 to 2029. Anything from 30 to 99 is taken as being as being 1930 to 1999. You need to enter 4 digits if the year is outside of these ranges.It depends on the two digits entered. Anything from 00 to 29 is taken as being the years 2000 to 2029. Anything from 30 to 99 is taken as being as being 1930 to 1999. You need to enter 4 digits if the year is outside of these ranges.


When you enter a certain series code from Club Penguin do you get that series of the treasure book to unlock items from?

No, you get the current series.