How to convert month in text format?

Help Studio
, ,
1

The image shows a spreadsheet listing purchase order numbers, dates, and descriptions. (Captioned by AI)
i need add column Month convert month text format.

2

@domsmgtmeet22,

Use Format Cells activity with custom format selected as desired Month format.

Thanks,
Ashok :slight_smile:

3

kindly share work flow

4

Formatteddate =Datetime.Parseexcat(inputdate,yourformat,System.globalisation.cultureInfo.InvariantCulture).tostring.(dd MMM yyyy)

5

kindly share work flow

6

In your work flow
Use for each row activity
And that for row item get the value of date column and than use assign activity with anyone mention line
And store it where you want

@domsmgtmeet22 kindly share your xaml flow here in case of issues,
thanks

7

@domsmgtmeet22,

Try this way.

This image shows an automation setup to open an Excel file, reference it, and format the cells in column B to display the full month name using a custom format. (Captioned by AI)
This image shows an automation setup to open an Excel file, reference it, and format the cells in column B to display the full month name using a custom format. (Captioned by AI)712×685 37.7 KB

SubFlow.xaml (7.4 KB)

image
image176×526 2.16 KB

8

i have only excel classic activity… kindly share another method

9

@domsmgtmeet22,

Use Format Cells classic activity in Excel Application Scope.

10

don’t format cell activity have

11

:slight_smile: domsmgtmeet22,

Ok in this case you only have VBA option.

Use Invoke VBA Activity.

Put this code in a text file and change the Sheet name and Column as per your data.

Sub Macro1()
    ThisWorkbook.Sheets("Sheet1").Columns("B:B").NumberFormat = "mmmm"
End Sub

If require you can refer this documentation on how to use it.

Thanks,
Ashok :slight_smile:

How to convert month text format?