如果您尝试在Excel或Google 表格^(Sheets)中写入以零 (0) 开头的数字，由于默认设置，您可能不会这样做。在这种情况下，您应该按照本教程在 Google 表格和 Microsoft Excel 中的数字前输入零^{(enter zero before a number in Google Sheets and Microsoft Excel)}。无需第三方插件即可完成。

Microsoft Excel和Google 表格^{(Google Sheets)}是两个救命工具，可帮助您创建包含不同数据的电子表格。与其他工具一样，它们也有一些限制或问题。例如，用户不能写这样的数字——00123 或 000012 或类似的东西。您选择哪一行或哪一列都没有关系；您无法在任一工具中输入此类数字。但是，有时，您可能需要在编写邮政编码、排名或其他任何内容时这样做。为此，您应该遵循我们在此处提到的这些技巧。在Google Sheets^{(Google Sheets)}和Microsoft Excel中，在数字前输入零主要有两种不同的方法。

如何在Excel和Google 表格^{(Google Sheets)}中的数字前添加零^(Zero)

要在Google 表格^{(Google Sheets)}和Excel中的数字前添加零，请按照以下步骤操作 -

1. 在写数字之前使用^(Use)撇号
2. 更改单元格格式

1]在写数字之前使用^(Use)撇号

这是完成工作的最简单方法，您可以在Google 表格^{(Google Sheets)}和Microsoft Excel中使用此技术。除了在写数字之前输入撇号之外，您不需要做任何其他事情。例如，您想在单元格中写入 00123。为此，您必须选择单元格并输入 - 00123。

它删除了单元格的默认格式，并允许您在开头写入带有零的整数。

2]更改单元格格式

如果您需要写很多数字并且第一种方法对您来说似乎很耗时，您应该更改单元格格式。这样，它就可以让你用纯文本写任何东西。为此，请选择一个单元格或整列，转到Format > Number > Plain text。

现在你可以写任何你想要的数字。供您参考，这些步骤适用于Google 表格^{(Google Sheets)}。如果您使用的是Microsoft Excel，您应该在不同的地方找到相同的选项。

确保您位于“主页”^{(Home )}选项卡上。现在，找到数字^{(Number )}部分并从相应的下拉菜单中选择文本。^(Text)

从现在开始，您可以输入任何您想要的数字。

第二种方法最好的一点是，您可以为不同的单元格选择不同的样式并不断添加各种条目。

How to add Zero in front of number in Excel and Google Sheets

If you are trying to writе a number in Excel or Google Shееts that starts with zero (0), you may not do that due to the defаult settings. In that casе, you should follow this tutorial to enter zero before a number in Google Sheets and Microsoft Excel. No third-party add-on is required to get it done.

Microsoft Excel and Google Sheets are two life-saving tools that help you create a spreadsheet with different data. Like other tools, they have some limitations or issues too. For example, users cannot write a number like this – 00123 or 000012 or anything like that. It doesn’t matter which row or column you choose; you cannot enter such numbers in either of the tools. However, sometimes, you may need to do that while writing a zipcode, rank or anything else. For that, you should follow these tricks that we mentioned here. There are mainly two different ways to enter zero before a number in Google Sheets and Microsoft Excel.

How to add Zero in front of number in Excel & Google Sheets

To add a zero before a number in Google Sheets and Excel, follow these steps-

1. Use an apostrophe before writing a number
2. Change cell formatting

1] Use an apostrophe before writing a number

It is the easiest method to get the job done, and you can use this technique in Google Sheets as well as Microsoft Excel. You do not need to do anything else apart from typing an apostrophe before writing the numbers. For instance, you want to write 00123 in a cell. To do that, you must select the cell and type this – 00123.

It removes the default formatting of the cell and allows you to write the whole number with zero in the beginning.

2] Change cell formatting

If you need to write a lot of numbers and the first method seems time consuming for you, you should change the cell formatting. That way, it will let you write anything in plain text. To do so, select a cell or the whole column, go to Format > Number > Plain text.

Now you can write any number you want. For your information, these steps apply to Google Sheets. If you are using Microsoft Excel, you should find the same options in a different place.

Make sure that you are on the Home tab. Now, find the Number section and select Text from the respective drop-down menu.

From now onwards, you can type any number you want.

The best thing about the second method is that you can choose different styles for different cells and keep adding various entries.

Related posts

• 如何在Excel and Google Sheets中显示Current Date and Time

• 如何在Excel and Google Sheets中创建下拉列表

• 如何使用Excel连接Google Sheets

• 如何在Excel and Google Sheets中制作弯曲的line graph

• 最好的Google Sheets and Excel Online Calendar templates

• 通过Google Drive创建直接链接到Google Sheets PDF链接

• Convert Word，PowerPoint，Excel Documents进入PDF，使用Google Docs

• Excel and Google Sheets中单个单元格中的Count comma分隔值

• 如何分割Text给Columns在Excel and Google Sheets

• 如何在Word and Google Sheets更改Text的Case

• 如何在Microsoft Excel中提取URLs中的域名

• 在没有Google Workspace subscription的情况下创建一个Google Sheets模板

• 如何在Excel中使用Automatic Data Type feature

• 如何在Microsoft Excel中使用HLOOKUP function

• 如何在Windows 11/10中创建Radar Chart

• 如何在Google Sheets Web应用程序中旋转文本

• 如何在Excel中使用Percentile.Exc function

• 如何在Excel中停止或关闭Workbook Sharing

• 如何使用NETWORKDAYS function在Excel

• 如何在 Excel 中隐藏工作表、单元格、列和公式