CiviCRM Community Forums (archive)

Second question today from a newbie...

I'm developing a search profile for displaying organizations across a number of cities.  One search criteria I'm offering is those cities' population, and I'm including those populations in the results column.  I'd like to have them all appear in the results screen right-aligned, with thousands-separators (",") - rather than left-aligned and with no commas, which is how they're currently displaying.  How can I do that?  Again, searching brings me no immediate answers.  Thanks again for your assists. 

~ Rob

Thanks, Erik.  Yes, it is a custom field.  It appears the only strictly numeric standard fields (ie, not phone, fax, or postal code) are longitude & latitude - where thousands-separators and alignment wouldn't be issues.  I had thought the localization settings only applied to currency - and checking it just now, this seems to be true.  My already-set defaults on that page are "US$" for currency type, "," for thousands separator,  and "." for decimal.  I don't see any place where I can apply any of these setting to integers or numbers.  I also just tried creating a custom number type field; that field type as well does not display the thousands separator.

But thanks for the reply.

Thanks again, Erik.  No, I don't know about editing templates yet.  I'll look into that.  Thanks.

~ Rob

Thanks for this - have read through it now - hope to have time to give it a try in a couple days ~

Not sure if this is helpful or not - but if you exposed your info via Views you would be able to control this through the Views UI - but that is a bit of a jump just to get around this issue