本文介绍了$符号在TEXT函数中是什么意思的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述

我找到了一个将日历日期转换成农历日期的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函数中是什么意思的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!

07-09 05:22