The .text property is what you see in the cell--not the .value.

If you have 543123.2341 and have it formatted as: #,###.00
you'd see: 543,123.23

If you skinny down that columnwidth enough, you'll see ###'s.

I'm not sure what you should happen if you could change the .text property.
Should xl figure out what numberformat/value combination should be applied to
get it?

Should it replace the .formula with a just a string value?

I'm kind of glad that there's a difference between .text and the rest.

wrote:

Thanks to all who replied.

But the question remains unanswered.

If something is read-write, then any property that *gets* to that
something should be read-write. Shouldn't it?

So is MS's having made ActiveCell.Text read-only just a fluke? If not,
what is the rationale?

Thanks again.

***

--

Dave Peterson