bb或bbbb在EN-US TEXT函数或“自定义数字”格式掩码中代表什么？ [英] What does bb or bbbb represent in an EN-US TEXT function or Custom Number format mask?

问题描述

在EN-US区域系统上， B 或 b 在格式掩码中代表什么？尽管它在VBA的

如果您查看上图中的数字转换，则这一定与日历年和leap年有关。除四分之三即366以外，它们之间的过渡通常看起来是365。根据当前系统时钟， 24 是自1900年1月1日以来的leap年数吗？

这可能是非格里高利历系统的格式掩码字符吗？我找不到关于此主题的任何文档（官方或其他资料）。

---

_{我被告知这是行为并非在所有系统上都表现出来。对我而言，这会同时出现在XL2010 Pro Plus和XL2013 Pro Plus（在64位EN-CA OS上均为EN-US 64位Office）}

解决方案

bb 和 bbbb 似乎是佛教历年，在泰国使用，仅是公历年加543。 bbbb 是4位数字，而 bb 是两位数字，对于 yyyy 和 yy 。

Excel的日期表示形式由以1900年1月1日（除非是1904年1月1日）。所以1 == 1900年1月1日，即2443年1月1日，您正在格式化年份2443。

On a EN-US regional system, what does B or b represent in a format mask? While it does nothing in VBA's Format function, both the TEXT function and Custom Number Formatting recognize b as a legal Number Format Code and return a number that I cannot determine the origin of.

To further confuse matters, larger numbers return different values when formatted with bbbb and while blocks of sequential numbers return the same value, there are transitions when they jump ahead a digit. I do know that Excel expects the format mask to be either bb or bbbb because if B or b is supplied as a custom number format Type: then it is corrected to bb and the same goes for BBB or bbb being corrected to bbbb.

  

If you look at the digit transitions in the above image then this must have something to do with calendar years and leap years. The transitions appear to generally be 365 between them except for every fourth which is 366. Is the 24 the number of leap years since 01-Jan-1900 according to the current system clock?

Might this be a format mask character for a non-Gregorian calendar system? I can find no documentation (official or otherwise) on the subject.

---

_{I've been told that this behavior is not exhibited on all systems. For me, this occurs in both XL2010 Pro Plus and XL2013 Pro Plus (both EN-US 64 bit Office on 64 bit EN-CA OS)}

解决方案

bb and bbbb appear to be formatting codes for the Buddhist calendar year, which are in use in Thailand and are simply the Gregorian year plus 543. bbbb is 4 digits and bb is two digits, as for yyyy and yy.

Excel has a date representation which consists of the count of days beginning with Jan 1 1900 (except when it's Jan 1 1904). So 1 == Jan 1 1900, which is Jan 1 2443 Buddhist, and you're formatting the year, 2443.

这篇关于bb或bbbb在EN-US TEXT函数或“自定义数字”格式掩码中代表什么？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！