If I understand you correctly, you are already able to convert multiple Excel files to Acrobat, but this isn't working for you because the Excel files are not formatted correctly.
Acrobat will not be able to format the Excel files correctly, and other than that, your workflow is fine.
Am I missing something? What is wrong with the formatting in Excel?
1 person found this helpful
Acrobat can't fix that, sorry. The issue is that the column is not wide enough to display the numbers. When text is cut off, Excel will display part of the cell and cut off the rest, but it won't do that with numbers. Otherwise you might think it said 30 when it was really 300,000. The spreadsheet will also print with the pound signs if you send it to your printer.
You need to ask on an Excel forum if there is a way to solve your problem. You want to autofit the columns—maybe using a macro or Visual Basic.
It is not an Acrobat issue.
Oh, a date is a number in Excel. January 1, 1900 is the number 1, formatted as a date.
You could also apply a different date format, such as m/d/yyyy or m/d/yy if the four digit year doesn't fit in that narrow column.
I didn't think there was a way, but figured I'd ask anyway. I thought it may be an excel issue and not Acrobat, but I couldn't find the excel forum on the Adobe site so I figured I'd post in Acrobat Thanks for your assistance.
Excel is a Microsoft product and Acrobat is an Adobe product, so that's why you didn't find Excel when you looked at the Adobe site. Not everyone who volunteers at this forum also knows Excel. I know Excel, but not Visual Basic. What you want to do is automate autosizing the columns with numbers so the entire number shows up. If it were an InDesigen table, I would send you to the scripting forum!
I did a Google search and found a couple of Excel forums. Here's one:
If you do get an Excel solution, I'd love to hear it.
Sorry, I misspoke. I meant to say I couldn't find it on Microsoft site. Thanks so much for the link.
If I get a solution, I'll let you know. Thanks again.
Oh, that makes so much more sense!