On Apr 8, 11:31 am, Greg Lovern wrote:
On Mar 27, 12:32 pm, Greg Lovern wrote:

I want to protect number format only, while allowing the user to
change the contents of the cells.

Any other suggestions?

We have over 25,000 users and growing, almost all of them outside our
organization. Educating all of them to always do a Paste Values would
be like -- who's the mythological character who spends eternity
pushing a boulder uphill only to have it roll back down each time?

BTW, ignore what I said about trailing zeros; that was a brain fart.
Trailing zeros are obviously not truncated. The problem is leading
zeros.

Thanks for any suggestions.

Greg

I was suffering with this 0 problem rather you brother.
i want to ware a suicide bomber belt and want to blast inside the
Microsoft Excel developer team hall and kill every bod ;x)