Text Becomes Decimal on Export to Excel
Ooookay, another little question. Maybe someone has seen this before and can explain it to me.
I have a text-type field with alphanumeric values like "16P" and "7A." ALL of them appear correctly in Access itself (table and forms).
When the table is exported to Excel, 99% of these values are fine. But some of them (right now it's 16P, but it's been a different value in the past) are converted into decimals!!
It does not do this every time you export, only sometimes, it's completely unpredictable. What on earth could be causing Excel to sometimes spontaneously interpret a text field as a decimal? <<see additional info added below!>>
Any and all thoughts are more than welcome and DEEPLY appreciated, because I don't even have guesses on this one. THANKS!!!! :help
-----> Additional Information To Add <-----
Okay, I have examined this bizarre event a little more. It's not entirely random: it is only happening on values that are #P, and by comparing the decimals produced, it definitely appears to be a constant formula of (# * P), with P having a value that rounds to about 0.0417.
If there is additional text in the cell besides #P -- even if it is just "#P and ##P" -- the text displays fine and this mysterious calculation doesn't occur.
This only happens on certain computers, meaning that whatever is going on must be a default setting somewhere in that computer's Excel load, but I don't know what or where.