[Year 12 Its] off topic (a little) sharing data between databases and spreadsheets

[Rob Attrill]

Sort of off topic but this seems the most likely place to get an answer.

Why would an excel  spreadsheet which receives data in a .txt file from 
a database correctly import data such as 11B, 11C, 12B or 12C, but 
stubbornly receive 11A as .485333333 and 12A as 0? It is clearly 
importing it in a numeric form despite all attempts to format the 
receiving cells as text. Obviously, I can find plenty of "can do" fixes 
(using an apostraphe to precede the data, etc), but the issue itself is 
bugging me.

regards
Rob Attrill
Mill Park Secondary College