Entering a 64 bit integer into Excel 2013

Question

I am attempting to enter 64 bit integers into Excel without success

For example, if I enter

8940964625324625950 Excel automatically converts it to

8940964625324620000

How can I force Excel to just accept the value I provide? Is it even possible? Even if I can force it, will Excel simply convert these numbers back when opened on a different machine with different settings?

Answer 1

Excel does not support 64-bit integers, numbers are treated as doubles and the precision is limited (aparently to 15 digits).

You can still display 8940964625324625950 in a cell though, as long as you change its Format to Text in the cell properties.