I want to remove the green triangle in the top-left corner of a cell in Excel

Japan Forum
1

Hello
I’m currently using StudioX 2024.10.14 LTS.

Recently, an expert taught me how to convert string types to numeric types using the generateDataTable activity, but is there a way to bulk convert values that have been pasted as strings in Excel to numeric types? I want to get rid of the green triangle in the top left of the cells.
Untitled

Using the format setting for selected cells doesn’t remove the green triangle in the top left. I can convert them one by one, but that’s inefficient, so I would like to know if there’s a method for mass conversion.

2

If you can’t make bulk changes on the Excel side,

you can only create a sample code that executes the following activities:

ReadRange (workbook) activity
↓
Output Datatable activity
↓
generateDatatable activity
↓
WriteRange (workbook) activity

This will have to be a self-resolved issue.