Excel Export - Numbers as Text

[ashish_2511]

Dear Community members -

I've a load field called TP which is calculated this way in the script -

IF (TP < 10, Num(TP,'#,##0.00'), If(TP >= 10 and TP < 100, Num(TP,'#,##0.0'), Num(TP,'#,##0'))) as TP

Condition is -

TP < 10 - 2 decimal points,

TP >=10 and TP<100 - 1 decimal point,

Else TP has no decimal point.

Then I’m using this field in a straight table but when I export it to excel it exports in ‘number converted as text’ format in excel.

I’ve seen many posts and tried many solutions nothing helped me. If the field didn’t have the above mentioned condition then it’s exporting in correct format.

Any help will be appreciated.

Thanks in advance.

[Anonymous]

I Format such an Expression as calculated Dimension or as Expression (whereever you want it)

if Expression you may Need an Expression like sum et.c

Image was just as example (left is calculated Dimension, right isExpression)

IF (TP < 10, Num(TP,'#,##0.00'), If(TP >= 10 and TP < 100, Num(TP,'#,##0.0'), Num(TP,'#,##0')))

[ashish_2511]

Hi Rudolf

Thanks for that

but I've already tried this. It still exports as 'numbers stored as text'

[vipin_mishra479]

Try Round function

=Round(86.656982, 0.01)

=Round(86.656982, 0.1)

=Round(86.656982, 0)

Hope this will help !!

[ashish_2511]

I tried this as a calculated dimension but didn't work.

=If(TP < 10, Round(TP,0.01), If(TP >= 10 and TP < 100, Round(TP,0.1), Round(TP,0))) //TP
-
0.94
2.3
3.5
3.9
3.5
4.5
-

[ashish_2511 · Accepted solution]

I solved this by using round function in an expression. It doesn't solve my problem fully but serves the purpose for now.

Anybody gets any idea on this do reply on this post. I'm closing this discussion.

Thanks! for all your replies.

Cheers!