Prevent comma-separated list of numbers being interpreted as single large value

Question

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

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")

giving it as 332,6650,033,266,510,000,000,000

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

Answer 1

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.

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.