java 路径分隔符转换_使用不同的分隔符转换货币

java 路径分隔符转换

Happy Thanksgiving, if you're celebrating today. Tomorrow is Black Friday – the biggest shopping day of the year, in the USA. Up here in Canada, we celebrate the day too, so I'll put one of my Excel products on sale for the day. Remember to check this blog tomorrow, to get the coupon code.

感恩节快乐，如果您今天要庆祝。 明天是黑色星期五-美国一年中最大的购物日。 在加拿大这里，我们也庆祝这一天，所以我将当天销售我的一种Excel产品。 记住明天要查看此博客，以获取优惠券代码。

If you're doing your shopping around the world, you might end up with a worksheet filled with amounts in a different currency. For example,

如果您要在世界各地购物，则最终可能会得到一个工作表，其中填充了不同货币的金额。 例如，

• In the USA, a comma is the Thousands separator, and a period is the Decimal separator -- 987.654,32

  在美国， 逗号是千位分隔符， 句点是十进制分隔符-987.654,32

• In Germany, a period is the Thousands separator, and a comma is the Decimal separator -- 987,654.32

  在德国， 句点是千位分隔符， 逗号是十进制分隔符-987,654.32

Fortunately, there is a quick way to fix things in Excel. You can use a built-in tool to change numbers from a German format, to the USA format.

幸运的是，有一种快速的方法可以解决Excel中的问题。 您可以使用内置工具将数字从德语格式更改为美国格式。

使用文本到列 (Use Text To Columns)

To fix currency that is in a format with different separators, use the Text To Columns command to convert the values.

要修复具有不同分隔符格式的货币，请使用“文本转列”命令转换值。

1. Select the cells that contain the numbers
   选择包含数字的单元格
2. Choose Data>Text to Columns
   选择“数据”>“文本到列”
3. In the Text to Columns window, click Next, twice
   在“文本到列”窗口中，单击“下一步”，两次
4. In Step 3, click the Advanced button
   在第3步中，单击“高级”按钮
5. From the Decimal separator drop down, select the separator that is currently used in the values -- "," (comma) in this example
   从“十进制分隔符”下拉列表中，选择当前在值中使用的分隔符-在此示例中为“，”(逗号)
6. From the Thousands separator drop down, select the separator that is currently used in the values -- "." (period) in this example
   从“千位分隔符”下拉列表中，选择值“-”中当前使用的分隔符。 (句点)在此示例中

7. Click OK, then click Finish.

   单击确定，然后单击完成。

Now get back to eating turkey and watching football games, and I'll see you back here tomorrow, for the Black Friday Sale.

现在回到吃火鸡，看足球比赛，明天我会再见到这里，参加黑色星期五促销活动。

翻译自: https://contexturesblog.com/archives/2014/11/27/convert-currency-with-different-separators/

java 路径分隔符转换