ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Access table exported to Excel does not preserve blank cells (https://www.excelbanter.com/excel-programming/304532-access-table-exported-excel-does-not-preserve-blank-cells.html)

Mike Collard

Access table exported to Excel does not preserve blank cells
 
Blank cells in an Access table when exported to Excel get
corrupted in some way so that the isblank() function
fails. If the apparently blank cell is highlighted, F2
pressed to edit and then the enter key pressed the cell
becomes truly blank.

Any ideas why this occurs and a solution?

Thanks

Mike Collard


All times are GMT +1. The time now is 10:28 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com