1 é 1 por quê

Excel for Microsoft 365 Excel for the web Excel 2021 Excel 2019 Excel 2016 Excel 2013 Excel 2010 More...Less

Índice Show

Need more help?
Need more help?
Contact Stop 1
Stop 1 Parkville

Microsoft Excel is preprogrammed to make it easier to enter dates. For example, 12/2 changes to 2-Dec. This is very frustrating when you enter something that you don't want changed to a date. Unfortunately there is no way to turn this off. But there are ways to get around it.

Preformat the cells you want to enter numbers into as Text. This way Excel will not try to change what you enter into dates.

If you only have a few numbers to enter, you can stop Excel from changing them into dates by entering:

A space before you enter a number. The space remains in the cell after you press Enter. (See Notes)
An apostrophe (‘) before you enter a number, such as ’11-53 or ‘1/47. The apostrophe isn’t displayed in the cell after you press Enter.
A zero and a space before you enter a fraction such as 1/2 or 3/4 so that they don’t change to 2-Jan or 4-Mar, for example. Type 0 1/2 or 0 3/4. The zero doesn’t remain in the cell after you press Enter, and the cell becomes the Fraction number type.

Select the cells that you’ll enter numbers into.
Press Ctrl + 1 (the 1 in the row of numbers above the QWERTY keys) to open Format Cells.
Select Text, and then click OK.

Select the cells you want to enter numbers into.
Click Home > Number Format > Text.

Notes:

We recommend using an apostrophe instead of a space for entering data if you plan on using lookup functions against the data. Functions like MATCH or VLOOKUP overlook the apostrophe when calculating the results.
If a number is left-aligned in a cell that usually means it isn’t formatted as a number.
If you type a number with an “e” in it, such as 1e9, it will automatically result in a scientific number: 1.00E+09. If you don’t want a scientific number, enter an apostrophe before the number: ‘1e9
Depending on the number entered, you may see a small green triangle in the upper left corner of the cell, indicating that a number is stored as text, which to Excel is an error. Either ignore the triangle, or click on it. A box will appear to the left. Click the box, and then select Ignore Error, which will make the triangle go away.

Need more help?

You can always ask an expert in the Excel Tech Community or get support in the Answers community.

Need more help?

Contact Stop 1

Stop 1 can connect you with the full range of student services to support your success while studying.

The Victorian Department of Health strongly recommends wearing a mask indoors and whenever you cannot physically distance. The University encourages everyone to follow this advice to help reduce the transmission of airborne viruses (all existing exemptions continue to apply). If needed, students and staff can access masks on campus as outlined here.

Stop 1 Parkville

757 Swanston Street, Parkville
(Main entrance off Grattan Street)

Hours

Monday to Wednesday:
9.00am – 4.45pm

Thursday to Friday:
10.00am – 4.45pm

1 O que era desde o princípio, o que ouvimos, o que vimos com os nossos olhos, o que temos contemplado, e as nossas mãos tocaram da Palavra da vida

2 (Porque a vida foi manifestada, e nós a vimos, e testificamos dela, e vos anunciamos a vida eterna, que estava com o Pai, e nos foi manifestada);

3 O que vimos e ouvimos, isso vos anunciamos, para que também tenhais comunhão conosco; e a nossa comunhão é com o Pai, e com seu Filho Jesus Cristo.

4 Estas coisas vos escrevemos, para que o vosso gozo se cumpra.

5 E esta é a mensagem que dele ouvimos, e vos anunciamos: que Deus é luz, e não há nele trevas nenhumas.

6 Se dissermos que temos comunhão com ele, e andarmos em trevas, mentimos, e não praticamos a verdade.

7 Mas, se andarmos na luz, como ele na luz está, temos comunhão uns com os outros, e o sangue de Jesus Cristo, seu Filho, nos purifica de todo o pecado.

8 Se dissermos que não temos pecado, enganamo-nos a nós mesmos, e não há verdade em nós.

9 Se confessarmos os nossos pecados, ele é fiel e justo para nos perdoar os pecados, e nos purificar de toda a injustiça.

10 Se dissermos que não pecamos, fazemo-lo mentiroso, e a sua palavra não está em nós.