How to prevent truncation of 0 in Excel sheet?

"Change the column type to Text

Right Click the column in question.
Select Format Cells...
Select the Number tab
Select Text

EDIT:

OK, try

Copy data from site
Right click A1 and choose past
special.
Select Text
Select Column A and use Text to
Columns
Select Fixed width and click Next
Remove unwanted breaks (in my case it
would be 2, 4 and 5) and click Next
Change Column 1 type from General to
Text

That should do it."

Prefix it with ' (single quote). That's a signal to Excel "treat this value as text".