Skip to main content
D
davida23545194
Participant
June 21, 2018
Answered

Excel to PDF, date format changes || Adobe PDFPack services.

  • June 21, 2018
  • 4 replies
  • 8208 views

Hi, I have been converting excel files to PDF and initially it was swapping round day/month in a date field i.e. 31/05/2018 turned in to 05/31/2018 - I took this to mean that it was trying to change into american date? So as I was not fussed about the format I changed the date to read 31 May 2018. When now changing this into a PDF it turns it into a line of #### with nothing else. Any assistance would be appreciated as this was the only reason I purchased this product to begin with.

This topic has been closed for replies.
Correct answer AnandSri

Hello Davida,

We're sorry for the delayed response and inconvenience caused. As per the description above, when converting an excel file to PDF the date format in the PDF file is changing, is that correct?

Try exporting the PDF file through the URL https://cloud.acrobat.com/convertpdf with your Adobe ID and password on a browser like Chrome, or Firefox, or Safari and see if this brings any difference.

Ideally, the date format should not change, try exporting any other excel file to PDF and check. If it is specific to one excel file, is it possible to share the excel file and the converted PDF with changed date format with us so that we can test it at our end?

To share the file, please use Adobe Send feature, login to https://cloud.acrobat.com/send using your Adobe ID(email) and password, upload the file, share the link to files via private message only, How Do I Send Private Message

The record shows that you are subscribed to Adobe PDFPack services, install the trial of Acrobat Pro DC and create the PDF file from excel and see if this issue is reproducible Download Adobe Acrobat DC (Continuous) for Enterprise or VIP licenses

You can also try the suggestions from Adobe discussion Converting an Excel document to pdf format.

Let us know how it goes and share your observation.

Thanks,

Anand Sri.

[Edited response]

4 replies

B
BoatmanS
Participant
December 16, 2023

For ##### issue: Increase the width of the column and the pdf export will be fine.

And issues with format change while exporting pdf will be soved if while saving as pdf you select 'save for print/printing'.

    D
    Daniel231751890k1k
    Participant
    August 31, 2023

    I just fixed the same problem, it didn't happen with months like May (short words) but with months like september it did. I fixed it by making the row bigger (cell wider) 

    D
    Donatella31950097g55q
    Participant
    September 1, 2023
    Ho risolto il problema, ora basta inviare le mail. Grazie
    A
    ArianL
    Inspiring
    May 11, 2023

    were you able to fix it? i am having the same issue

    F
    Fincar31855865s1yr
    Participant
    August 24, 2023

    I find if you save the excel to PDF and select "Best for Printing" option as opposed to the default selected option of "Best for Electronic distribution and acessibility" it keeps the date same format

    AnandSri
    Community Manager
    AnandSriCommunity ManagerCorrect answer
    Community Manager
    August 25, 2018

    Hello Davida,

    We're sorry for the delayed response and inconvenience caused. As per the description above, when converting an excel file to PDF the date format in the PDF file is changing, is that correct?

    Try exporting the PDF file through the URL https://cloud.acrobat.com/convertpdf with your Adobe ID and password on a browser like Chrome, or Firefox, or Safari and see if this brings any difference.

    Ideally, the date format should not change, try exporting any other excel file to PDF and check. If it is specific to one excel file, is it possible to share the excel file and the converted PDF with changed date format with us so that we can test it at our end?

    To share the file, please use Adobe Send feature, login to https://cloud.acrobat.com/send using your Adobe ID(email) and password, upload the file, share the link to files via private message only, How Do I Send Private Message

    The record shows that you are subscribed to Adobe PDFPack services, install the trial of Acrobat Pro DC and create the PDF file from excel and see if this issue is reproducible Download Adobe Acrobat DC (Continuous) for Enterprise or VIP licenses

    You can also try the suggestions from Adobe discussion Converting an Excel document to pdf format.

    Let us know how it goes and share your observation.

    Thanks,

    Anand Sri.

    [Edited response]

    Terms & ConditionsAccessibility statement
    Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices