Excel.1个特定列的特殊数字分隔符格式，整个文档不使用 [英] Excel. Special number separator format for 1 specific column, no for the entire document

问题描述

在Excel的文档中，当您在特定的单元格(例如数字 223715 )中输入正6位数字(XXXXXX)时，我需要用Excel自动将数字格式化为223'71'5 (将数字写到单元格中，然后按Enter键或移到另一个单元格等).

In an Excel's document, I need when you enter a positive 6 digits number (XXXXXX) into a specific cell like for example, the number 223715, then Excel automatically format the number as 223'71'5 once you write the number into the cell and you press Enter or move to another cell, etc.

除了前面解释的内容外，我还需要在您输入5位数字时，然后Excel自动添加结尾的' 0 '以将数字格式填写为6位数字，因此，如果您插入数字 22589 ，然后Excel自动将其转换为 225'89'0

In addition to the previous explained, I need when you enter a 5 digits number, then Excel automatically adds an ending '0' to complete the number format to 6 digits, so if you insert the number 22589, then Excel automatically converts it to 225'89'0

最重要的部分是我需要给这个特殊"提示.在单个列或一组特定的特定单元格中设置仅格式，因为例如，我尝试修改Excel的设置，该设置允许使用所需的数字分隔符，但它会在整个文档中准确地生效我不需要的，因为我主要需要使用标准方式的Excel文档，但是某些列/单元格具有这种特殊格式.

The most important part is I need to give this "special" format ONLY in one single column or defined set of specific cells, because for example, I tried modifying an Excel's setting that allows to use the number separator you want but it takes effect in the entire document that is exactly what I don't need, because I need to mainly have the Excel documents in a standard way but with some columns/cells with this special format.

我尝试了多种自定义数字单元格格式，例如" ###'##'#0.00 "，" ###'##'#000'00'0 "和类似的组合试图获得积极的结果，但目前还没有运气.

I tried with multiple custom Number Cell Format like "###'##'#0.00", "###'##'#000'00'0" and similar combinations trying to get positive results but no luck for now.

推荐答案

尝试以下自定义格式: [< = 99999] ###'##'\ 0; ###'##'#

Try this custom format: [<=99999]###'##'\0;###'##'#

5位数字

6位数字

这篇关于Excel.1个特定列的特殊数字分隔符格式，整个文档不使用的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！