Topic: help formatting please Posted: 13 Aug 2007 at 11:25am
I have a report that returns long distance numbers dialed. I would like to be able to insert hyphens within the numbers.
So, instead of the North American calls showing up as 1234567890, I'd like it to show them as 123-456-7890. Further, if the number starts with 011 (international calls), I'd like it to stay the same, no formatting.
Joined: 20 Nov 2006
Online Status: Offline
Posts: 3702
Posted: 14 Aug 2007 at 5:24pm
If this is a text field instead of a number field, you can skip the "after converting number to string" part of socrates response. The formula for doing this looks something like:
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum
IP Logged
