Thread: Exporting formatting
2013-10-27, 04:49 #1
- Join Date
- Feb 2001
- Thanked 0 Times in 0 Posts
I have an Access 2010 report, which is based on a query, which includes a "Net surcharge or discount" field (Net S/D for short) .
The data is stored in a table as a number in a field named "Adjustment".
The query uses a calculated field to convert the data in the table to a decimal in the query (Net S/D: [Adjustment]/100), which correctly converts (e.g.) 125 to 1.25, or -50 to -.5.
The report uses a format mask to display the field from the query as positive, negative, or blank (+#%;-#%;"";""), which correctly displays (e.g.) 1.25 as +125%, or -50 as -50%, both in Access and when exported to a PDF file.
However, when exported to an Excel file, every cell in the column for this field appears blank, whether it contains a value or not, but if a cell containing a value is manually overtyped with the same value, then it is made visible (see attached example). Selecting the column in Excel and applying Format Cells > Percentage also makes values visible. How can I adjust the formatting in the Access report so that the field is exported to Excel with the values visible and not appearing blank, or is this a bug or setting in Access or Excel?
Subscribe to our Windows Secrets Newsletter - It's Free!
Get our unique weekly Newsletter with tips and techniques, how to's and critical updates on Windows 7, Windows 8, Windows XP, Firefox, Internet Explorer, Google, etc. Join our 480,000 subscribers!
+ Get this BONUS — free!
Get the most of Excel! Learn about new features, basics of creating a new spreadsheet and using the infamous Ribbon in the first chapter of Excel 2013: The Missing Manual - Subscribe and download Chapter 1 for free!