When I download the results of a web query into Excel, some columns have leading or trailing zeroes removed. How can I get the real data to show up?

We send web query results in CSV (comma-separated-values) format, which Excel will open and import automatically. This is usually a good thing. But for some RKM values (like 023 or 522.100) or coil IDs (like 09), Excel will automatically make those fields appear as numbers without the leading (or trailing) zeros.

To take control of the import process, download our CSV file and replace the file's "csv" extension with a "txt" extension. Then start Excel and import the data file. This will trigger Excel's import wizard and allow you tell Excel what data type each column should be imported as.

Import the RKM and/or coil ID columns as text and the leading/trailing zeros will be formatted correctly. More.

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.

Related Questions