Alphanumeric field formatting

[#1]

We have a field that we download that contains Credit Limit information.   It is alphnumeric as we have some customers with credit limits CAD, HOLD, TT, LIA etc.

I would like to format the numerical credit limits appropriately #,## so the comma separator shows up but also keep the data that is alpha

I tried a formula like :  if(LIMIT>0, num(LIMIT,#,##), LIMIT)

but this just make the alpha entries blank. 

[anlonghi2 · Accepted solution]

Hi Cam,

try with the following formula:

if(isnum(LIMIT), num(LIMIT,'#,##'), LIMIT)

Best regards

Andrea

[#3]

Gracias!