Changes in number format

[praneshsapmm]

Hello ,

Can any one help me on this . 

When i see the output through Browse attached to Layout the number format is this : -286,929,513 but when i generate output in excel the numbering format changed to : -28,69,29,513 . 

Can any one help me to restrict this change. 

Thanks.

[echuong1]

How are you inputting the commas, what formula are you using?

I suggest using the tostring() formula. If you use the following expression, it should give you what you're looking for. The 0 placeholder is for the decimals shown, the 1 signifies to add commas.

ToString([Field1],0,1)

[praneshsapmm]

Hi ,

Thanks for the response. 

If i apply below formula on numeric field it returns error : 

Field is numeric but string is returned. 

Do i need to create new field and try it . Then in such case it's a lot many fields.

Thanks

[praneshsapmm]

Hi Again ,

Iam trying to convert the numeric field in table tool column rule as shown : 

Not sure what's wrong it does not work to retain the same comma separated values in the output file.

Thanks.