Export Numbers as Text

  • Thread starter Thread starter Bill Sturdevant
  • Start date Start date
B

Bill Sturdevant

I have a field in a table that is defined as text.
Sometimes the field most often, but not always, contains
numeric data.

Upon exporting to an Excel spreadsheet, how can I force
the format of the field to be "Text" in the spreadsheet?
 
Create a query with all the fields in the table that you want exported. Use
the format command on the field you want converted:
Expr1: Format([test],"0")
The format command will convert the number to text. Then export the query
and not the table.
 
I have done some testing and your suggestion does not seem
to work, or I have implemented it incorrectly...

In my table, I have the following values:
3.0
4.5
5.0B2

When I export them to Excel they become:
3
4
5.0B2

I WANT them to stay the same as in the table:
3.0
4.5
5.0B2

-----Original Message-----
Create a query with all the fields in the table that you want exported. Use
the format command on the field you want converted:
Expr1: Format([test],"0")
The format command will convert the number to text. Then export the query
and not the table.

--
--Roger Carlson
www.rogersaccesslibrary.com
Reply to: Roger dot Carlson at Spectrum-Health dot Org

I have a field in a table that is defined as text.
Sometimes the field most often, but not always, contains
numeric data.

Upon exporting to an Excel spreadsheet, how can I force
the format of the field to be "Text" in the spreadsheet?
Click to expand...


.
Click to expand...
 
Sorry, I mis-read your original post. I thought you had numeric values that
you wanted exported as text. But in my testing, a text field with the
values below will export them as text, just like you want.

How are you exporting them?
--
--Roger Carlson
www.rogersaccesslibrary.com
Reply to: Roger dot Carlson at Spectrum-Health dot Org

Bill Sturdevant said:
I have done some testing and your suggestion does not seem
to work, or I have implemented it incorrectly...

In my table, I have the following values:
3.0
4.5
5.0B2

When I export them to Excel they become:
3
4
5.0B2

I WANT them to stay the same as in the table:
3.0
4.5
5.0B2

-----Original Message-----
Create a query with all the fields in the table that you want exported. Use
the format command on the field you want converted:
Expr1: Format([test],"0")
The format command will convert the number to text. Then export the query
and not the table.

--
--Roger Carlson
www.rogersaccesslibrary.com
Reply to: Roger dot Carlson at Spectrum-Health dot Org

I have a field in a table that is defined as text.
Sometimes the field most often, but not always, contains
numeric data.

Upon exporting to an Excel spreadsheet, how can I force
the format of the field to be "Text" in the spreadsheet?
Click to expand...


.
Click to expand...
Click to expand...
 
Back
Top