Hi guys, I am using DU to extract info from PDF files to excel. All the fields were extracted correctly apart from the purchase order number column which extracted such (see screenshot). How do I go about it to ensure the numbers are well displayed? Please help [image]

Hi @J_Crosby , Maybe you could check on the Format Cells Activity and let us know if it works for your case : [image] How to put dot for 1k numbers to excel column Studio @Kuki_Force Use format cell activity [image] cheers

Getting Excel to display large numbers

Help Studio

supermanPunch (Arpan) October 18, 2023, 8:49am 2

Hi @J_Crosby ,

Maybe you could check on the Format Cells Activity and let us know if it works for your case :

Topic		Replies	Views
Numer formatted as text in cell Studio	9	1953	April 7, 2020
How to put dot for 1k numbers to excel column Studio excel , use-excel-file	11	1147	April 24, 2023
Can anyone please help me to extract data from pdf and store in to excel Studio studio , question , activities_panel	1	563	October 18, 2022
Unable to get output from pdf to excel activity Help activities	8	892	September 21, 2019
Get the exact large number from the excel file Studio excel , uiautomation , activities , studio , question , activities_panel	9	1052	October 12, 2023

Most Active Users - Yesterday
sharazkm32
ashokkarale
V_Roboto_V
Anil_G
adilhassanpost
Hosam_Alzahrani
gorby
Sreekumar_Sedharth
adi.mehare
stary
More details...

Getting Excel to display large numbers

Related topics