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.


--
putty
------------------------------------------------------------------------
putty's Profile: http://www.excelforum.com/member.php...o&userid=35430
View this thread: http://www.excelforum.com/showthread...hreadid=552008

Putty

I can't replicate this...any other steps to repro?

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
HIS


"putty" wrote in
message ...

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.


--
putty
------------------------------------------------------------------------
putty's Profile:
http://www.excelforum.com/member.php...o&userid=35430
View this thread: http://www.excelforum.com/showthread...hreadid=552008

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.

Nick Hodge Wrote:
Putty

I can't replicate this...any other steps to repro?

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
HIS


"putty" wrote in
message ...

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.


--
putty

------------------------------------------------------------------------
putty's Profile:
http://www.excelforum.com/member.php...o&userid=35430
View this thread:
http://www.excelforum.com/showthread...hreadid=552008



--
putty
------------------------------------------------------------------------
putty's Profile: http://www.excelforum.com/member.php...o&userid=35430
View this thread: http://www.excelforum.com/showthread...hreadid=552008