$符号在TEXT函数中是什么意思 [英] What does the $ sign mean in TEXT function

问题描述

我找到了一个将日历日期转换成农历日期的excel公式:

I found an excel formula that transforms calendar dates into Chinese lunar dates:

=TEXT(A1,"[$-130000]d/m/yyyy")

说A1是

08/12/2018

公式的输出为

2/11/2018

这是如何工作的?什么是$?什么是$-130000? 关于TEXT的MS帮助文章没有提及.

How does this work? What is $? What is $-130000? The MS's help article on TEXT does not mention this.

我可以使用什么公式进行反向计算，即从阴历到阳历? $+130000不起作用.

What formula can I use to do the reverse calculation, i.e. from lunar calendar to solar calendar? $+130000 does not work.

我刚遇到关于SO的答案，其中说[$ -xxxx]是一些区域设置代码，对我来说很有意义.但是，我找不到任何消息说130000代表什么.

I just came across this answer on SO, which says [$-xxxx] is some locale code, which makes perfect sense to me. However, I cannot find any source says what locale 130000 represents.

推荐答案

如果您仍在寻找有关[$ -130000]代表什么的答案，请在此处查看我的其他答案.

If you are still looking for an answer about what does [$-130000] represent then check out my other answer here.

130000在Excel语言环境代码[$ -130000]是什么意思?

我不确定如何进行逆向转换.如果您尝试执行上述功能的相反操作，那将是...

I am not certain how to do a reverse conversion. If you try to do the reverse of the above function, which would be...

=TEXT(A1, "[$-1010409]d/m/yyyy")

但这只是获取显示的日期，然后将其转换为指定的格式(即，它已经将"A1"中的所有内容视为公历日期)

But this simply takes the presented date, and converts it to the stated format (i.e. it sees whatever in "A1" as a Gregorian date already)

这篇关于$符号在TEXT函数中是什么意思的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！