跳到主要内容

如何在Excel中向多个正数添加加号？

在某些情况下，您可能希望在正数前添加加号+，如果直接在数字前键入加号，则不会显示加号。 在Excel中，您可以转换格式单元格以将加号添加到多个正数。 请阅读本文以了解更多详细信息。

使用格式单元格功能将加号添加到多个正数

使用格式单元格功能将加号添加到多个正数

要在多个正数之前添加加号，只需按以下步骤设置单元格格式：

1。 选择要在正数上添加加号的范围。

2.然后右键单击并选择 单元格格式 从上下文菜单中，查看屏幕截图：

文档添加加号 1

3。 在 单元格格式 对话框，单击 定制版 下 联系电话 标签，然后输入 +0; -0; 0 到 Type 文本框，请参见屏幕截图：

文档添加加号 1

4. 然后点击 OK，并且您的正数立即添加了加号。 查看屏幕截图：

文档添加 plus1

在Excel中轻松更改值的符号：

Kutools for Excel's 改变价值观 实用程序可以快速更改值的符号，例如在Excel中的选择中将所有负值更改为位置，反之亦然，如下图所示。 立即下载并试用！ (30-天免费试用）

最佳办公生产力工具

热门特色: 查找、突出显示或识别重复项   |  删除空白行   |  合并列或单元格而不丢失数据   |   不使用公式进行四舍五入 ...
超级查询: 多条件VLookup  |   多值VLookup  |   跨多个工作表的 VLookup   |   模糊查询 ....
高级下拉列表: 快速创建下拉列表   |  依赖下拉列表   |  多选下拉列表 ....
列管理器: 添加特定数量的列  |  移动列  |  切换隐藏列的可见性状态  |  比较范围和列 ...
特色功能: 网格焦点   |  设计图   |   大方程式酒吧   |  工作簿和工作表管理器   |  资源库 （自动文本）   |  日期选择器   |  合并工作表   |  加密/解密单元格   |  按列表发送电子邮件   |  超级筛选   |   特殊过滤器 （过滤粗体/斜体/删除线...）...
前 15 个工具集:  12 文本 工具 (添加文本, 删除字符，...）   |   50+ 图表 类型 (甘特图，...）   |   40+ 实用 公式 (根据生日计算年龄，...）   |   19 插入 工具 (插入二维码, 从路径插入图片，...）   |   12 转化 工具 (小写金额转大写, 货币兑换，...）   |   7 合并与拆分 工具 (高级组合行, 分裂细胞，...）   |   ... 和更多

增强您的 Excel 技能 Kutools for Excel，体验前所未有的效率。 Kutools for Excel 提供 300 多种高级功能，可提高工作效率并节省时间。  单击此处获取您最需要的功能...

kte选项卡201905

Office Tab 为 Office 带来选项卡式界面，让您的工作更轻松

  • 在Word，Excel，PowerPoint中启用选项卡式编辑和阅读，发布者，Access，Visio和Project。
  • 在同一窗口的新选项卡中而不是在新窗口中打开并创建多个文档。
  • 每天将您的工作效率提高50％，并减少数百次鼠标单击！
Comments (18)
Rated 5 out of 5 · 1 ratings
Eko
Eko
This comment was minimized by the moderator on the site
sebuah solusi yang sangat bagus untuk mempermudah pekerjaan, SUPEEER SEKALEEEE!!!
Reply
0
0
Rated 5 out of 5
MandyZhou
MandyZhou     Eko
This comment was minimized by the moderator on the site
Hello,
Glad it helps. Any questions, please feel free to contact us. Have a great day.
Sincerely,
Mandy
Reply
Report
0
0
Sm
Sm
This comment was minimized by the moderator on the site
Thanks. That was really useful
Reply
0
0
Wasi
Wasi
This comment was minimized by the moderator on the site
I want to write +A Panel,
how can I do?
Reply
0
0
Foam
Foam
This comment was minimized by the moderator on the site
ขอบคุณค่ะ เป็นประโยชน์มากเลย
Reply
0
0
mehedi.h.bd@gmail.com
This comment was minimized by the moderator on the site
I want this 10+10=20 (10+10 in one cell and =20 for another cell result)
Reply
Report
0
0
mesh
mesh
This comment was minimized by the moderator on the site
How do i add a plus sign with phone number in CSV format?
Reply
0
0
Fauzan
Fauzan     mesh
This comment was minimized by the moderator on the site
="+"& (contoh C3)
Reply
0
0
Gulam Murtuza
Gulam Murtuza     mesh
This comment was minimized by the moderator on the site
press ctrl+1 a dialogue box will appear, in category column select custom Tab, a box will appear at right side
in Type: type +0;-0;0 if you want add + sign before a number or if you want to add - sign before a number use -0;+0;0 and click ok, the required sign will get add to your nubmer.
Reply
0
0
shah
shah
This comment was minimized by the moderator on the site
i want a farmola 20+17=37 but i want he made 20+17=40 3 or 2 or 1 auto add in passing marks please tell me if any bodu known about it thanks regard shah jee
Reply
0
0
Carlos
Carlos
This comment was minimized by the moderator on the site
Can you tell me how to put +0.25. I learn how to put + sign, but the zero disappier I work with prescriptions lens and its very important both, positive sign as the zero. can you help me please. Thank you in advance
Reply
0
0
Divakar Arjunan
Divakar Arjunan     Carlos
This comment was minimized by the moderator on the site
@Carlos: use +#,##0.00;-#,##0.00;#,##0.00
Reply
0
0
Carlos
Carlos     Divakar Arjunan
This comment was minimized by the moderator on the site
Divakar Arjunan, Thank you so much for your help, works for me!
Reply
0
0
Adam
Adam     Carlos
This comment was minimized by the moderator on the site
[quote]Can you tell me how to put +0.25. I learn how to put + sign, but the zero disappier I work with prescriptions lens and its very important both, positive sign as the zero. can you help me please. Thank you in advanceBy Carlos[/quote] Hey Carlos - having the same issue!... did you figure out how to do this? My current numbers show "+1.15" etc. but numbers between 0 and 1 show as "+.15" but I want to see "+0.15". Thanks, A.
Reply
0
0
Carlos
Carlos     Adam
This comment was minimized by the moderator on the site
Adam, use Divakar Arjunan code's : +#,##0.00;-#,## 0.00;#,##0.00
Reply
0
0
AATIR
AATIR
This comment was minimized by the moderator on the site
Thanx a lot. It made my work simple.
Reply
0
0
joseph
joseph
This comment was minimized by the moderator on the site
i like your demonstration on how to make + appear on multiple positive numbers. How can I get more tutorials from you about excel? or where can I ask you more about excel applications?
Reply
0
0
There are no comments posted here yet
Please leave your comments in English
Guest
Posting as Guest
×
Rate this post:
Reset
0   Characters
Suggested Locations