the number in this cell is formatted as text and preceded by an apostrophe Help

[brandon20]

Hi,

I am having a data export issue from access to an excel .xlsx file. I am using Access 2010.

I am trying to export a column of numbers. But when it exports and I look in excel, the numbers all have a green indicator saying
"the number in this cell is formatted as text and preceded by an apostrophe"

I need these to just export as numbers.

The reason this is happening is because I needed to display blanks in some of the cells in the column, these cells must be blank but the other cells must be numbers.

How can I have these columns export as numbers and not be preceded by an apostrophe?



Here is the SQL I had to edit to ensure it exported certain cells as blanks.
SQL View:

iif(Last([DEV].MD)=10,null,Last([DEV].X)) AS TD_X,




Thanks,
Any help is appriciated

 

[mole999]

to get rid of the apostrophe, find ' and replace, its useful when you have leading zeros that fail to display correctly

 

[brandon20]

Hi,

Thanks for your help, I had thought to do that. But my goal was to export this sheet regularly and not have to step into it and do a find/replace.

In the end, when I did a find replace it did not find the '
So, not sure why it states that there is one. I ended up exporting the data with formatting and layout button clicked. This solves the issue, "the number in this cell is formatted as text and preceded by an apostrophe" does not show up anymore.

My one issue with exporting it with the layout button clicked is that it exports the data with "wrap text" on, I would like this to not be on but it is a very very minor issue.

Thanks again.