AWhere, Inc.

I just started using AWhere Express and am having trouble figuring out how to format numeric labels. Some of my labels are percentages, some dollars, etc. The numeric formats in the Excel spreadsheet are ignored and in AWhere, so far, all numbers are expressed to four decimal places with out any numeric indicator like $ or % or separators (,) for large numbers.  That makes the labels very difficult to read and uninformative. I am sure there must be a way to format the numbers. Can someone steer me the right direction?

Hi Thomas,

Currently AWhere only has the ability to set numeric delimiters and decimal places, which appear in the legend tab or under the attribute if "Show Legend in Layer Treeview" is selected in the "Display Properties" tab.

If you need symbols like % and $, you can edit the "Units" by right clicking on the attribute, select properties and edit the "Units" drop down menu.  Either select something there, or enter your own.  This will add the unit or symbol to the end of the value in the legend.

If you need those symbols in your labels on the map, you can create a new field in the table view, make it "text" and use the field calculator to copy the numeric data into it while appending a "$" to the beggining for instance.  Something like: YourField="$ " & [MoneyField] would work.  Then you would have a special text label field.  The draw back is you can not perform any mathmatical functions on this new text field.

---

Michael Swaim
GIS Analyst / Cartographer
AWhere, Inc.