英文:
How do I set a cell to be a number but to also have mg after?
问题
我想记录几个物品的重量，以毫克为单位，并且希望只需在单元格中键入一个数字，然后它就会显示数字后面加上“mg”。
我有一种感觉，也许可以通过自定义数字格式来实现，我尝试过，但似乎会改变数字并搞乱一切。
肯定有一种简单的方法吧？
我尝试过使用自定义数字格式。
我原本期望在单元格中输入30，然后显示为30mg。
英文:
I want to record the weight of a few items in milligrams, and I want it to be that I just type in a number in a cell and then it has the number but adds mg afterwards.
I get the feeling I may be able to do this with custom number formats and I have tried, but it seems to change the number and mess everything up.
Surely there's an easy way?
I've tried going to custom number formats.
I was expecting to type into a cell 30 and it come up as 30mg
答案1
得分: 1
你可以在菜单中使用“自定义数字格式”选项。要进入该选项，您可以点击顶部菜单栏中的“格式” -> “数字” -> “自定义数字格式”。
你要查找的示例在这里。
英文:
You can use the Custom number format option in the menu. To get to it, you go to Format (in the top menu bar) -> Number -> Custom number format.
An example of what you're looking for is here.
通过集体智慧和协作来改善编程学习和解决问题的方式。致力于成为全球开发者共同参与的知识库，让每个人都能够通过互相帮助和分享经验来进步。
评论