如何在Excel 2007中将字符串解释为数字？ [英] How to interpret string as a number in Excel 2007 ?

问题描述

大家好！

我有点困惑。 。 。

我导入了一个包含处理器工作负载的日志。这些数字的格式如下：

27.314168336673351

因为这个"数字"是指将'。'作为小数点分隔符，Excel将其解释为字符串。

Excel是否具有任何功能或格式选项将其解释为数字??

A玩右键 - > "格式化单元格......"，但它对我没有帮助。 。 。

解决方案

您好，

此论坛适用于Office Live，而非Office产品。您最好的选择是在Office讨论组的一个Excel论坛中发布此信息，地址为 http： //www.microsoft.com/office/community/en-us/default.mspx 搜索结果，罗伯特

Hello everyone!

 

I've been a little confused. . . 

I have imported a log, that contains a processor workload. The numbers have a format, like this:

27.314168336673351

 

Because this "number" have '.' as decimal separator, Excel interprets it as string.

 

Does Excel have any function or format option to interpret this as number ??

 

A have played with Right click--> "Format Cells...", but it does not helps me. . .

解决方案

Hello,

This forum is for Office Live, not Office products. Your best bet would be to post this in one of the Excel forums in the Office Discussion Groups at http://www.microsoft.com/office/community/en-us/default.mspx

Robert

这篇关于如何在Excel 2007中将字符串解释为数字？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！