如何在Excel中更改默认数字格式? [英] How to change the default number format in Excel?

问题描述

我一直都在通用"类型中使用此字符串整数列.每次打开此电子表格时，都必须将其转换为数字"类型.但是，当我这样做时，它会自动创建两个小数点.例如，它将"12345"更改为"12345.00".每次都使用减少十进制"有点烦人.有什么办法可以对默认模式进行两项更改? 1)始终假定该列为数字"类型，而不是常规"类型 2)不能有任何小数点.

I have this column of string integers in the 'general' type all the time. Every time I open this spreadsheet, I have to convert it into 'number' type. But when I do it, it automatically creates two decimal points. For example, it changes '12345' to '12345.00'. It's kinds of annoying to use 'Decrease Decimal' every time. Is there any way to make two changes to the default mode? 1) Always assume that the column has 'number' type, not 'general' type 2) To not have any decimal points.

推荐答案

设置工作簿的格式选项

Setting Formatting Options for Workbooks

Excel没有提供许多选项来允许您设置格式 工作簿的默认设置.但是，您可以通过以下方法解决此问题 修改空白工作簿中的格式，然后将其另存为 默认模板.

Excel does not offer many options that allow you to set formatting defaults for your workbooks. However, you can work around this by modifying the formatting in a blank workbook, then saving it as the default template.

1. 打开Excel到空白工作簿.
2. 使用所需的所有选项来格式化空白文件.例如，设置页边距，单元格颜色格式或设置页眉或页脚.确保 删除您在单元格中输入的任何值以测试格式，除非 您希望它们出现在每个空白工作簿中.
3. 进行更改后，单击文件"选项卡，然后选择另存为".

4. 从文件类型"下拉列表中，选择"Excel模板(* .xltx)"，然后将文件名更改为"Book".

1. Open Excel to a blank workbook.
2. Format the blank file with all options desired. For example, set margins, cell color formats, or set up a header or footer. Make sure to remove any values you entered in cells to test formatting unless you want them to appear in every blank workbook.
3. Once your changes are made, click on the File tab and choose Save As.

4. From the "Files of type" drop-down list, select "Excel Template (*.xltx)" and change the file name to "Book."

将保存位置"位置设置为XLSTART文件夹.该文件夹通常位于与C:Program Files/Microsoft Office/Office14/XLSTART相似的路径中.

Set the "Save in" location to theXLSTART folder. This folder is typically located in a path similar to C:Program Files/Microsoft Office/Office14/XLSTART.

• 找到其位置的最快方法是使用Visual Basic编辑器(VBE)中的立即"窗口，如下所示:
• 按 Alt + F11 启动VBE.
• 如果立即"窗口不可见，请按 Ctrl + G .
• 在立即窗口中，键入? application.StartupPath并按 Enter .
• VBA将显示XLStart的路径.

• The quickest way to find its location is to use the Immediate window in the Visual Basic Editor (VBE), as follows:
• Press Alt+F11 to launch the VBE.
• If the Immediate window isn’t visible, press Ctrl+G.
• In the Immediate window, type ? application.StartupPath and press Enter.
• VBA will display the path to XLStart.

这篇关于如何在Excel中更改默认数字格式?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！