Excel write as numeric instead of text (value is ienumerable)

Hi Guys,

1 Read pdf
2 Regex text from this read pdf
3 Match regex this text
4 Write match output to excel

Heres my issue, the excel sheet is new, formatted as general.
Numbers are aligned left so excel is seeing them as text.
Ive tried preformatting these columns as numbers but that didnt work.
Ive tried formatting these columns as numbers after they were written, also didnt work.
The values im writing are of ienumerable from the mathes output.
As you can see I cant perform calcs in column J
I tried replacing .ToString with numeric but errored out.

Thanks guys

Screenshot 2022-04-25 141131

Screenshot 2022-04-25 142333

Hi Guys,

Figured it out with modify text, trim left and right.
Writes as numeric now :grinning:
Its weird as in the excel formula bar I double checked for leading and trailing whitespaces.

Screenshot 2022-04-25 153153

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