RE: MI label expression dropping commas

2000-06-13 Thread Jennifer Duncan
This is actually because MapInfo turns numbers to integers to characters when it concatenates. This gets rid of the commas. You can use functions to make it work though. I actually answered a version of this for one of my training clients before. We wrote up a quick FAQ for them. While it

RE: MI label expression dropping commas

2000-06-13 Thread Lindsay Giles
Aaron - Try this: Format$(field1,",#.##") + chr$(13) + Format$(field2",#.##") if both field 1 and 2 are numbers you wish to show with a comma. The expression (field1,",#.##") means to take field1 and display it with a comma as the thousands separator and 2 decimal places. If no decimals are r