--- In [email protected], "Margaret Young" <[EMAIL PROTECTED]> wrote: > > In a map I am creating I need to label stores with their weekly > sales . The sales field is an integer, example: 300000. I need the > label to read "$300K" What is the best way to do this? > > Thanks, > Margaret > Margaret,
Not sure if my message went through. Try this formula: "$" + String(Round([FIELD]/1000,0) + "K" where [FIELD] is the field name containing the sales value. Let me know if you have questions. Michael ------------------------ Yahoo! Groups Sponsor --------------------~--> See what's inside the new Yahoo! Groups email. http://us.click.yahoo.com/2pRQfA/bOaOAA/yQLSAA/C5grlB/TM --------------------------------------------------------------------~-> Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/Maptitude/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
