Thnaks to all the replies...

A couple of them I had already tried myself with varying levels of success but was having troubles with variation in the labelling of the sigificant figures. ie, anything like 23.01 would label as 23. but 23.23 would lable 23.23.

But then resident legend Peter Horsbøll Møller gets into work and supplies an expression I even understand and kick myself for not thinking of. Cheers Peter and thanks to all that replied.

Tony

Troy Wiora wrote:

I use

Format$(FIELD, "#")

where FIELD is your label. I asked the same question in April of 2004 and got several answers, but Tim Nuteson's worked best for me.

http://lists.directionsmag.com/discussion/read.php?f=7&t=39595&a=2

Troy
GIS Tech
Rural Metro Fire/Southwest Ambulance - for 2 more days





*Tony Baylis <[EMAIL PROTECTED]>*
Sent by: [EMAIL PROTECTED]

01/17/2006 08:34 PM
Please respond to
[EMAIL PROTECTED]


        
To
        Mapinfo-L <[email protected]>
cc
        
Subject
        [MI-L] Labelling numeric fields


        





Afternoon all

I have a large table with a numeric field I need to label BUT it
contains many zero values.  I do not wish to label the zeroes.  Can you
use an expression in the label tool such as:

If FIELD>0 Then FIELD

If this does not work does anyone have any other work around?

Cheers

Tony
--
Tony Baylis
Spatial Information Specialist
Resource and Exploration Mapping
Suite 8, 290 Boundary St
Spring Hill QLD 4000
Ph    3832 1600
Fax   3832 1603
Mob   0419 759 131
Email [EMAIL PROTECTED]
www resexmap.com.au _______________________________________________
MapInfo-L mailing list
[email protected]
http://www.directionsmag.com/mailman/listinfo/mapinfo-l

------------------------------------------------------------------------

* This communication may contain confidential and/or proprietary
information
and may not be disclosed to anyone other than the intended addressee.
Any other disclosure is strictly prohibited by law. If you are not the
intended addressee, you have received this communication in error.
Please
notify the sender immediately and destroy the communication including
all
content and any attachments. Thank you. *


--
Tony Baylis
Spatial Information Specialist
Resource and Exploration Mapping
Suite 8, 290 Boundary St
Spring Hill QLD 4000
Ph    3832 1600
Fax   3832 1603
Mob   0419 759 131
Email [EMAIL PROTECTED]
www   resexmap.com.au   
_______________________________________________
MapInfo-L mailing list
[email protected]
http://www.directionsmag.com/mailman/listinfo/mapinfo-l

Reply via email to