Excel 2007: copy/paste formatted cells?

P

putty

Hi all. I've got a question regarding 2007. If I copy/paste a cell with
a formatted date in it, the pasted cell gets a 12:00 am added at the
end of the date. I can't seem to stop this.

Any ideas or is this just a bug? TIA.
 
P

putty

Strange... after playing around a bit I've noticed that it only happens
to formatting done in Excel 03 and opened in Excel 07 where the
copy/paste is done. I guess it's just a bug but if any work-around is
figured out, I'd love to hear it.

Thanks.
 

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

I can't copy and paste equations 0
data turned in date format when copied 2
paste web without date format 1
Excel 2007 Problem Paste/Enter Key 0
excel 2007 - copying cells with conditional formating 2
Number Format Changes During VBA Copy/Paste 2
Copy and Paste in Excel, copies cell and formula, but shows same v 3
Is Paste Special HTML broken in Excel/Office 2007? 1

Top