I am trying to import a table from Quickbooks. I save the excel file but
when I open the file one column of data is wrong. It is numerical data (ie
6000:6105) and I suspect that excel is performing a calculation on the data.

I tried to reformat the data as text but that does recreate the original
data. I have tried to turn off the auto-calculation on the options menu but
the menu change does not seem to stay in place when I open the file.

Is the colon an operator?