Convert text format to number format

image

@Manju_Reddy_Kanughula,

From where you are populating this excel,

Through regular expression I’m writing into Excel.

HI @Manju_Reddy_Kanughula

You have activity called Formet Cells in Modern Excel

To enable Modern
Go to → Activities Panel → Click on Filter → Select Show Modern.

image

Use this in source

Excel.Sheet("SheetName").Range("A:A")

Regards
Sudharsan

how can i take dynamic Range?

You can use LookupRange Activity and search for the Column header @Manju_Reddy_Kanughula

Lookuprange will get you the address of the column like A1 from that string you will get only the alphabet and giving it as range

Excel.Sheet("SheetName").Range(System.Text.RegularExpressions.Regex.Match(String2,"\D+").ToString+":"+System.Text.RegularExpressions.Regex.Match(String2,"\D+").ToString)

Here String2 is the Variable from the Lookup range

Regards
Sudharsan

Hi @Manju_Reddy_Kanughula ,

It can be easily done using the VBA code.
For that we should enable the developer access to Excel application in the environment.

  1. The design for your requirement

  2. Save the VBA code in your location with extension .vba [Ex: ConvertSpecificColumnTONumberFormat.vba]

Code:

Function ConvertColumnToNumberFormat()
    ActiveSheet.Select
    [A:A].Select
    With Selection
        .NumberFormat = "General"
        .Value = .Value
    End With
End Function

[A:A] is your column where you need to convert the column to number format.

Please let me know if your need additional details.

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