Hi, I have copied the data from one excel file to another using read range(complete sheet) and white range to waste in the 2nd excel file. Here a column assume column C has values as text(greencolor marks) and i wanted to convert the Whole column as number. Because my next step is vlookup using t…

Hi @Sarah2 Use a build data table activity to build the data table to support the data you are reading. So have all the columns pre designed. There you can have the column that hold these numbers in a numeric data type. Then use it in the read range to read and hold the data. While reading it will …

Convert to numbers

Help

Sarah2 (Sarah) October 1, 2019, 8:28pm 3

@Jarzzz copy and paste is working …i need to convert a particular column values as numbers excel-error-convert-number
Attached is the required activities…i have to the same with uipath …
I have tried to send hot keys but its not working

1 Like

Datable Column as string. Need as Integer

Topic		Replies	Views
How to convert to number in excel? Insights question , insights	34	859	July 31, 2023
How to convert variable datatype while getting from Excel Help datatable , activities	28	4425	September 5, 2019
Convert number text to number in excel and how to sum up the column? Help excel , uiautomation , studio	9	4947	July 24, 2023
Text To number Robot robot , question	6	289	August 9, 2023
Convert number to excel cell Help excel , activities , question	9	729	October 23, 2020

Most Active Users - Yesterday
Anil_G
Ajay_Mishra
pravallikapaluri
postwick
AJ_Ask
Anonymouss
vignesh.maruthappan
mkankatala
mrohan.senapaty
ATHEEQ_UR-RAHMAN
More details...

Convert to numbers

Related Topics