Select all the rows from a specific "Amount" column and format


#1

Hey Guys

I’m stuck doing a task, need help with it. Appreciate the help!

I’m trying to select all the rows of a specific “Amount” column, and format them. Initially its all just numbers, we need to format those and convert into $.
For example:
Lets say “22,33,44,55” are few row elements of that column, we have to format them into “$22,$33,$44,$55”

Thanks
LaxmiSample data.xlsx (8.9 KB)


#2

Simplest approach is to simulate human actions, open the excel file and perform the steps, use recording facility to record the steps and create a workflow.