Converting Datatype from General to Number

Help Studio
, ,
1

Hi,
I have some data which after pasting into new sheet gets converted into general datatype. I need to convert it into number format and it has to be right aligned.
I have attached the sheet containing all the columns that needs to be converted.
NumberSheet.xlsx (12.0 KB)
Please let me know how to solve this?
Thanks in advance!!

2

Hi @Kunal_Jain ,

Was the Format Cells activity tried out ?

3

HI @supermanPunch
No I have not tried it.
But is there some way by which only this 4 columns can be converted into number format.
Because I have more data and that has to be in general format only which I have not shared here in this sheet.
Cheers!!

4

@Kunal_Jain ,

We should be able to get the Cell Range columns (A:A, B:B, C:C,…) and then use it as the Range in Format Cells activity.

5

Hi @supermanPunch
We don’t have the last value of the range for the column.
What should we do in that case??
Ex: A1:A?

6

@Kunal_Jain ,

The representation provided above could act as an Array of List,

columnRangesToFormat = {"A:A","C:C","E:E"}

We could loop through this Array and provide the iterative value one by one to the Format Cells Activity.

7

Hi @supermanPunch
Can you help me with the workflow to understand it better please.
Cheers!!

8

I hope this will help. Just replace the workbook path to your local file path

9

Hi @AJ_Ask

image
image1366×768 109 KB

Can you please share the zip file for the same.
It is showing document is invalid
Cheers!!

10

ConvertNo_General.zip (3.5 KB)

11

@Kunal_Jain ,

Could check with the below :
Excel_FormatColumns.zip (13.0 KB)

12

Hi @supermanPunch
Thanks for the solution, it worked.

1 Like
13

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.