Excel美元符号文本没有被转换为数字 [英] Excel dollar sign text not being converted to a number
问题描述
例如。 10英镑自动对齐。使用公式 = VALUE(A1)
会返回10。这在使用€符号时也有效。但是,如果使用$符号,则将该值识别为文本,并使用上述公式得到 #VALUE!
。也许这与我的Windows区域/语言设置是有关英国而不是美国。
编辑:我有会计格式下的两个条目:
£英语(英国)
$英语(美国)
。我用 = VALUE(REPLACE(A1,1,1,))
来删除美元符号,只是得到数字的值,数字就可以使用'$ English(US)'会计格式进行格式化。
When I input Euro or Sterling values into an excel sheet, they are automatically recognized as numbers/currency and right aligned and I can also extract their value.
e.g. £10 is automatically right aligned. Using the formula =VALUE(A1)
returns 10 as it should. This also worked when using the € symbol. However if I used the $ symbol, the value is recognized as text and using the above formula results in #VALUE!
. Maybe it has something to do with my Windows regional/language settings which are for UK not US.
EDIT: I have two entries under accounting formats: £ English (U.K.) $ English (U.S.)
I figured out a work around for anyone with a similar problem. I used =VALUE(REPLACE(A1,1,1,""))
in order to remove the dollar sign and just get the value of the number, the number can then be formatted using the '$ English (U.S.)' accounting format.
这篇关于Excel美元符号文本没有被转换为数字的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!