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

Jarzzz (Kyle) October 1, 2019, 8:35pm 4

@Sarah2 It might be easier to use a Macro of sorts… Quick start: Create a macro

Can you link an example spread sheet and the flow you have so far?

Ttext to number excel

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

Most Active Users - Yesterday
ashokkarale
MD_Farhan1
Ajay_Mishra
postwick
Dheerendra_vishwakarma
Anil_G
chandreshsinh.jadeja
Gautham_Pattabiraman
vrdabberu
aravindbalineni123
More details...

Convert to numbers

Related Topics