How to Get Decimal Numbers from PDF to Exce

%3CLINGO-SUB%20id%3D%22lingo-sub-2052690%22%20slang%3D%22en-US%22%3EHow%20to%20Get%20Decimal%20Numbers%20from%20PDF%20to%20Exce%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2052690%22%20slang%3D%22en-US%22%3E%3CP%3EHi%3C%2FP%3E%3CP%3E%3CBR%20%2F%3EI%20am%20currently%20using%20the%20office%20365%20and%20trying%20to%20import%20the%20data%20from%20PDF%20files%20to%20Excel%20In%20this%20case%2C%20If%20I%20import%20the%20files%20as%20it%20is%2C%20the%20numbers%20will%20be%20treated%20as%20text%20values%20and%20excel%20cannot%20plot%20any%20graphs%20from%20these%20numbers.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESo%20in%20Power%20query%20editor%20window%2C%20i%20have%20changed%20them%20into%20a%20whole%20value%20and%20later%20imported%20these%20numbers.%20But%20post%20importing%2C%20we%20are%20not%20able%20to%20get%20the%20decimal%20values.%20For%20e.g%20actual%20number%20of%20a%20column%20is%204.75%20and%20after%20converting%20this%20into%20a%20whole%20number%2C%20it%20is%20changed%20to%205.%3C%2FP%3E%3CP%3ELater%20post%20importing%20this%20into%20excel%2C%20it%20will%20show%20as%205.%20When%20we%20increase%20the%20decimal%20values%20for%20this%20number%2C%20it%20will%20show%205.00.%20and%20not%204.75.%3C%2FP%3E%3CP%3EIs%20there%20a%20way%20to%20import%20data%20from%20PDF%20to%20excel%20in%20a%20number%20format%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERegards%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2052690%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EPower%20BI%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2052820%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20Get%20Decimal%20Numbers%20from%20PDF%20to%20Exce%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2052820%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F926194%22%20target%3D%22_blank%22%3E%40Vaishali175%3C%2FA%3E%26nbsp%3BSelect%20the%20data%20type%20in%20PQ%20to%20%22Decimal%20Number%22%20after%20import%2C%20i.e.%20NOT%20%22Whole%20Number%22.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

Hi


I am currently using the office 365 and trying to import the data from PDF files to Excel In this case, If I import the files as it is, the numbers will be treated as text values and excel cannot plot any graphs from these numbers.

 

So in Power query editor window, i have changed them into a whole value and later imported these numbers. But post importing, we are not able to get the decimal values. For e.g actual number of a column is 4.75 and after converting this into a whole number, it is changed to 5.

Later post importing this into excel, it will show as 5. When we increase the decimal values for this number, it will show 5.00. and not 4.75.

Is there a way to import data from PDF to excel in a number format

 

Regards

 

1 Reply

@Vaishali175 Select the data type in PQ to "Decimal Number" after import, i.e. NOT "Whole Number".