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

[MikeC (Mike)]

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

[MikeC (Mike)]

Hi Guys,

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