Preserve text format to Excel

[Guest]

I export a bi-weekly report to MS Excel to send to a bank. The file contains
bank routing numbers that are formatted as text in Access, but they show up
as "General" in Excel and initial zeros are dropped. Is there a way to
preserve the text format so that the zeros are retained?
Thank you for your consideration.

 

[Guest]

Hi George,

I would suggest exporting from a query rather than a table (if you are not
already). In the query you can use the format function to make sure that the
text field is formatted properly. In the query you can put
Format([myfield],"00000000") and that will make sure that you show 8
characters (it is saved as text).

Please let me know if I can provide more assistance.

 

[Guest]

Many thanks, hmadyson,
That worked fine! I was exporting from a report and had tried the format
approach there, but it did not work. Ir works from a query.

Hi George,

I would suggest exporting from a query rather than a table (if you are not
already). In the query you can use the format function to make sure that the
text field is formatted properly. In the query you can put
Format([myfield],"00000000") and that will make sure that you show 8
characters (it is saved as text).

Please let me know if I can provide more assistance.

I export a bi-weekly report to MS Excel to send to a bank. The file contains
bank routing numbers that are formatted as text in Access, but they show up
as "General" in Excel and initial zeros are dropped. Is there a way to
preserve the text format so that the zeros are retained?
Thank you for your consideration.

 

[Lina]

Hi hmadyson,
I am having the same porblem when exporting to a csf file. I tried
this approach and it is still truncating the leading zeros when I open
the csv file.
Any ideas?

Thanks!

Hi George,

I would suggest exporting from a query rather than a table (if you are not
already). In the query you can use the format function to make sure that the
text field is formatted properly. In the query you can put
Format([myfield],"00000000") and that will make sure that you show 8
characters (it is saved as text).

Please let me know if I can provide more assistance.

I export a bi-weekly report to MS Excel to send to a bank. The file contains
bank routing numbers that are formatted as text in Access, but they show up
as "General" in Excel and initial zeros are dropped. Is there a way to
preserve the text format so that the zeros are retained?
Thank you for your consideration.- Hide quoted text -

- Show quoted text -