I often paste data sent to me into a master spreadsheet. Many times the data
I get contains cells that have formats that are different from the ones I
want to use. (font, size, etc). It's not practical for me to have my users
change them before they send them, and I'd like to avoid the hassle of
converting them all manually. Is there a way for me to paste the rows of
data into my sheet and have the formats automatically change to the ones that
I want to see? Could I lock the formats somehow?

Thanks

What happens if you paste special|values?



kcrad wrote:

I often paste data sent to me into a master spreadsheet. Many times the data
I get contains cells that have formats that are different from the ones I
want to use. (font, size, etc). It's not practical for me to have my users
change them before they send them, and I'd like to avoid the hassle of
converting them all manually. Is there a way for me to paste the rows of
data into my sheet and have the formats automatically change to the ones that
I want to see? Could I lock the formats somehow?

Thanks

--

Dave Peterson

That works - I thought I had tried that.

Thanks for the simple solution!



"Dave Peterson" wrote:

What happens if you paste special|values?



kcrad wrote:

I often paste data sent to me into a master spreadsheet. Many times the data
I get contains cells that have formats that are different from the ones I
want to use. (font, size, etc). It's not practical for me to have my users
change them before they send them, and I'd like to avoid the hassle of
converting them all manually. Is there a way for me to paste the rows of
data into my sheet and have the formats automatically change to the ones that
I want to see? Could I lock the formats somehow?

Thanks

--

Dave Peterson