Losing Original Cell Format when pasting in cells

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Excel 2003. Have a need to keep original sheet cell Format when pasting data
into cell(s) from other sources. Have tried paste special values, but that
also changes cell format and ignores validations set up. Have tried all the
Protect security options which work fine when manually entering data into
cell(s), but fail to support a paste of data into a cell. Basically have
several users entering data from several sources and wish to maintain
original cell format integrity and validations.
 
Couple of approaches here...
http://tinyurl.com/yxtyaf
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware



"mrbill" <[email protected]>
wrote in message
Excel 2003. Have a need to keep original sheet cell Format when pasting data
into cell(s) from other sources. Have tried paste special values, but that
also changes cell format and ignores validations set up. Have tried all the
Protect security options which work fine when manually entering data into
cell(s), but fail to support a paste of data into a cell. Basically have
several users entering data from several sources and wish to maintain
original cell format integrity and validations.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Merge Cell Cut & Paste 1
retain custom date format "text" when pasting or reformatting data 2
protect cell format 1
Prevent paste from re-formatting cell 4
Remove date format? 3
Copy & Paste cell that has alt + enter 2
Formatting not protected when paste 7
Multiple Cells - Data Validation/Conditional Formatting 1

Back
Top