Skip to main content

Regional Settings

Updating your currency and date settings for your region

Written by Team PDF2XL

Some PDF documents will contain numbers that are not in standard regional settings.

In order to convert such numbers or dates correctly:

  1. Right-click the problematic column or field, and select the relevant column format.

  2. Go to the Settings.ย 

  3. Delete all the text in the "(Number, Date, Currency, or Time) Cell Format" box.

  4. Go to your Control Panel > Clock, Language, and Region > Change the date, time or number format.

    1. Change the Format to the correct regional settings (example, Italian or Portuguese). Click the "Additional Settings" button to see that decimal point and the 1000 separator are the ones found in the document.

Did this answer your question?