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.
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)
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
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.