How to display long number as text?

[fionna51]

Hi,

I am working on following field which most values are like number but is in fact text. For those two highlighted, they contain a "D" and a "B", then the display is correct. For all others, they are still text. Even I use text(), it is still displayed as +14. This field is read from Excel file, is this the issue?

[vishsaggi]

What happens when you try like

Text(Num(yourfieldname))

[el_aprendiz111]

Hi,

num#(MyNum, '#','.',',')

num#(MyNum, '#,##0.00','.',',')

num#(MyNum, '#,#','.',',')

[fionna51]

Those are not working.

Please note, some of this value contain letters, when I tried Num(), the letter's gone, and still like 1.3456788883344e+14.

[fionna51]

And, when I extract from Excel and saved as qvd, this field shows correct format. After left join to my fact table as additional field, it shows wrongly.

[fionna51 · Accepted solution]

Finally, I worked it out. Thanks for your hint.

if(isnum(fieldname, Text(Num(fieldname,'0')), fieldname)