Prev: Using TransferSpreadsheet Macro to import a single sheet from exce
Next: Datasheet view on a form
From: Arlene on 7 Apr 2010 16:32 The report I am transfering has 9 columns of numbers. In some of the columns the numbers are 3 ceros (000) or 003, etc. when I transfer the report to excel, the numbers are changed from 000 to just 0. How can I prevent excel from changing the 000 to only one 0 or the 003 to 3?
From: Steve on 7 Apr 2010 16:50 003 is not a number! 003 is text. Change the format of the Excel column to text. Steve santus(a)penn.com "Arlene" <Arlene(a)discussions.microsoft.com> wrote in message news:FEAEAFB530A74F0EB4EB38C569844AA6(a)microsoft.com... > The report I am transfering has 9 columns of numbers. In some of the > columns > the numbers are 3 ceros (000) or 003, etc. when I transfer the report to > excel, the numbers are changed from 000 to just 0. How can I prevent excel > from changing the 000 to only one 0 or the 003 to 3?
From: Jerry Whittle on 7 Apr 2010 16:54 Instead of exporting a report, export a query with the same data. Use the CStr or Format functions to change the numbers to text. Right now Excel sees the results as numbers therefore strips off any leading zeros.  Jerry Whittle, Microsoft Access MVP Light. Strong. Cheap. Pick two. Keith Bontrager  Bicycle Builder. "Arlene" wrote: > The report I am transfering has 9 columns of numbers. In some of the columns > the numbers are 3 ceros (000) or 003, etc. when I transfer the report to > excel, the numbers are changed from 000 to just 0. How can I prevent excel > from changing the 000 to only one 0 or the 003 to 3?
From: soso on 8 Apr 2010 10:35 كتب "Arlene" <Arlene(a)discussions.microsoft.com> في رسالة news:FEAEAFB530A74F0EB4EB38C569844AA6(a)microsoft.com... > The report I am transfering has 9 columns of numbers. In some of the > columns > the numbers are 3 ceros (000) or 003, etc. when I transfer the report to > excel, the numbers are changed from 000 to just 0. How can I prevent excel > from changing the 000 to only one 0 or the 003 to 3?

Pages: 1 Prev: Using TransferSpreadsheet Macro to import a single sheet from exce Next: Datasheet view on a form 