Cell Format

[Guest]

I use a label macro to put labels on chart points ..
Sometimes the data comes in as dates when the text is 4-17. Even if I
format it as text the point labels are dates. How do I get around this.

windows 2000
excel xp

thanks much

 

[Guest]

You could try:

Chart1.Series.Points.DataLabels.NumberFormat = "Text"

Change Chart1 to actual.
The data labels would normally pick up the format from the source reference.
If it is not doing it then the above should reset the labels format. I have
not tested it, so it might need some tweaking.