blocks|key|3804710|text|尝试将$替换为nothing，)替换为nothing，(替换为-。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|3804711|entityMap^0|3|1|F|1|R|1|V|1|0^^$0|@$1|2|3|4|5|6|7|H|8|@$9|I|A|J|B|C]|$9|K|A|L|B|C]|$9|M|A|N|B|C]|$9|O|A|P|B|C]]|D|@]|E|$]]|$1|F|3|-4|5|6|7|Q|8|@]|D|@]|E|$]]]|G|$]]

Try replace <code>$</code> with nothing, <code>)</code> with nothing and <code>(</code> with <code>-</code>.

blocks|key|3260867|text|用于将数字($6,437.55)转换为货币数据类型的完整语法：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3260868|CASE+WHEN+IsNumeric(Replace(Replace(Replace([INPUT-COLUMN-NAME],+',',+''),')',''),'(','-'))+=+1+Then+Cast(Replace(Replace(Replace([INPUT-COLUMN-NAME],+',',+''),')',''),'(','-')+AS+Money)+ELSE+0+END+As+[OUTPUT-COLUMN-NAME]|code-block|syntax|javascript|3260869|这可以直接在SQL语句中使用，如选择ColumnA，如上面所示的情况，表中的ColumnC。加入等。|3260870|您还可以定义一个类似的函数(它附带性能损失)，并在select语句中使用函数。|3260871|CREATE+FUNCTION+dbo.ConvertStringToMoneyType(@input_Number+varchar(50))
RETURNS+MONEY
AS
BEGIN

Declare+@Output_Number+money+=+0

Set+@Output_Number+=+CASE+WHEN+IsNumeric(Replace(Replace(Replace(@input_Number,+',',+''),')',''),'(','-'))+=+1+Then+
++++++++Cast(Replace(Replace(Replace(@input_Number,+',',+''),')',''),'(','-')+AS+Money)+ELSE+0+END

RETURN+@Output_Number


END
GO|3260872|entityMap^0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|O|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|P|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|Q|8|@]|9|@]|A|$]]|$1|I|3|J|5|6|7|R|8|@]|9|@]|A|$]]|$1|K|3|L|5|D|7|S|8|@]|9|@]|A|$E|F]]|$1|M|3|-4|5|6|7|T|8|@]|9|@]|A|$]]]|N|$]]

Complete syntax for converting numbers like ($6,437.55) to money data type:

<pre><code>CASE WHEN IsNumeric(Replace(Replace(Replace([INPUT-COLUMN-NAME], ',', ''),')',''),'(','-')) = 1 Then Cast(Replace(Replace(Replace([INPUT-COLUMN-NAME], ',', ''),')',''),'(','-') AS Money) ELSE 0 END As [OUTPUT-COLUMN-NAME]
</code></pre>

This can be used directly in SQL statement like
Select ColumnA, CASE WHEN as above, ColumnC
From Table.. join etc.

You can also define a function like (which comes with a performance penalty though) and use function in select statement.

<pre><code>CREATE FUNCTION dbo.ConvertStringToMoneyType(@input_Number varchar(50))
RETURNS MONEY
AS
BEGIN

Declare @Output_Number money = 0

Set @Output_Number = CASE WHEN IsNumeric(Replace(Replace(Replace(@input_Number, ',', ''),')',''),'(','-')) = 1 Then 
 Cast(Replace(Replace(Replace(@input_Number, ',', ''),')',''),'(','-') AS Money) ELSE 0 END

RETURN @Output_Number


END
GO
</code></pre>

blocks|key|3260890|text|在未使用的单元格中键入1。复制它。选择存储为文本的数字，并选择主剪贴板-粘贴-粘贴特殊-乘。删除1。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|3260891|entityMap^0|B|1|1C|1|0^^$0|@$1|2|3|4|5|6|7|H|8|@$9|I|A|J|B|C]|$9|K|A|L|B|C]]|D|@]|E|$]]|$1|F|3|-4|5|6|7|M|8|@]|D|@]|E|$]]]|G|$]]

Type <code>1</code> into an unused cell. Copy it. Select the numbers that are stored as text and select Home - Clipboard - Paste - Paste Special - Multiply. Delete the <code>1</code>.

I have Excel data that has parentheses around negative values, but Excel does not see them as negative values, it seems to take them as text. E.g. trying to sum cells that have ($25.00) and $50.00 gives #VALUE! error.

The data is imported from a csv file.

It's not a formatting issue, changing negative value formatting does not change anything. So, how do I convert these values to actual negative numbers?

Thanks.

Here is some sample data in case someone wants it. So the values in parentheses are supposed to be negative numbers but seem to be text at the moment.

<pre><code>($25.00)
 $50.00
($35.00)
($15.00)
</code></pre>

Convert numbers with parentheses around to negative numbers

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

涵盖代码开发、场景应用、自动测试全流程，助你从零构建专属AI助手

一站式MCP教程库，解锁AI应用新玩法

我的Excel数据在负值周围有括号，但Excel并不将其视为负值，而是将它们视为文本。例如，尝试将有($25.00)和$50.00的单元格相加会给出#值！错误。数据是从csv文件导入的。这不是格式化问题，更改负值格式不会改变任何事情。那么，如何将这些值转换为实际负数呢？谢谢。这是一些样本数据，以防有人想要。所以括号中的...

问将带括号的数字转换为负数
EN

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问将带括号的数字转换为负数EN