Excel 2000. Access97. SQL Server 2000.

I have even tried adding an ' before the number - it comes out as '00003. I think I found away around this though. If I extract the query instead of the report, it does not drop the zero's! Go figure