Skip to main content
C
Carlos30682017gjdq
New Participant
June 23, 2023
Question

Exporting PDF To Excel (Format Problems with thousand separator).

  • June 23, 2023
  • 1 reply
  • 615 views

Hi, all!

 

I'm attempting to export a credit card statement from PDF to Excel. The issue is that the statement uses a point as a thousand separator (I'm based in Latin America). However, Acrobat Web recognizes the point as a decimal separator, resulting in completely inaccurate data. I have specified that the output format should be in Spanish.

 

Unfortunately, I cannot locate any menu options to resolve this problem in the web App (Acrobat Web).

 

Do any of you have any ideas on how to fix this issue?

 

Thank you very much for your help.

 

Carlos.

This topic has been closed for replies.

1 reply

try67
try67
Braniac
June 23, 2023

You can do a Search & Replace command in Excel to remove the periods, and then replace the commas (used as the decimal separators) with periods.

C
Carlos30682017gjdqAuthor
New Participant
June 23, 2023

Thank you very much, try67, for your answer. Your solution is greatly appreciated.

 

I would like to add an observation. I remember that when I initially used the Adobe software (although I'm unsure of the exact version because I was experimenting with the conversion capabilities), I didn't encounter this conversion problem. This issue may be specific to the basic version of Adobe web? Not sure about this...

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