防止将逗号分隔的数字列表解释为单个大值 [英] Prevent comma-separated list of numbers being interpreted as single large value

问题描述

33266500,332665100,332665200,332665300是原始值，单元格应如下所示:33266500,332665100,332665200,332665300，但是我在excel中看到的单元格值是3.32665E+34

33266500,332665100,332665200,332665300 was the original value, cell should look like this: 33266500,332665100,332665200,332665300 but what I see as the cell value in excel is 3.32665E+34

所以问题是我想将其转换为原始字符串.我已经在Google上找到了格式化功能，并且像这样

So the question is I want to convert it into the original string. I have found format function on google and I used it like these

format(3.32665E+34,"standard")

将其命名为332,6650,033,266,510,000,000,000

如何解析它或获取原始字符串?我相信格式是vba中的功能.

How to parse it or get back the orginal string? I belive format is the function in vba.

推荐答案

Excel的精度限制为15位数字.如果在访问文件时已经像这样显示了数字，则无法找回数字-您已经丢失了一些数字. VBA代码和公式将无济于事.

Excel has a 15 digit precision limit. If the numbers are already shown like this when you access the file, there is no way to get the number back - you have already lost some digits. VBA code and formulas will not help you.

如果不是这种情况，则可以在数字之前添加单引号'标记以将其存储为文本.这样可以确保Excel不会尝试将其视为数字，从而导致精度下降.

If this is not the case, you can add a single quote ' mark before the number to store it as text. This will ensure Excel does not try to treat it as a number and thus lose precision.

这篇关于防止将逗号分隔的数字列表解释为单个大值的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！