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:FEAEAFB5-30A7-4F0E-B4EB-38C569844AA6(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:FEAEAFB5-30A7-4F0E-B4EB-38C569844AA6(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