Excel 2007: copy/paste formatted cells?

[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.

[Nick Hodge]

Putty

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

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


"putty" <[email protected]> wrote in
message news:[email protected]...
>
> 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]

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.

Putty

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

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


"putty" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>