Problem with Data table formating from text to number

Help Studio
1

Hi.

How can I convert text columns into number

image

I’m using this macro for formating column E

Sub macro()

[E:E].Select
With Selection
.NumberFormat = “#,###0.00”
.Value = .Value
End With

end sub

and it is formated well, but just after clicking excel cell.
How can I force data table to format text data to number when writing to excel?

2

@okalinic

check the thread

3

Hi @okalinic

Can you try with Format Cells activity

image
image828×867 34.5 KB

image
image931×338 15.9 KB

Regards,

4

May not work for all use cases, but have you tried creating a pre-formatted spreadsheet and using it as a template?

Said that, I think the solution provided by @lrtetala is also a good choice.

5

I’ve tryed, but not working…Format is OK only after I click excel cell and it’s still showing “Number sored as Text” message…

6

Not possible as I am using dinamic creating of Excel files…

7

I’ve tryed this suggestion too, but it doesn’t work either… Formating is visible only after clicking excel cells…