I'm using XL2003. According to the Help file for Keyboard Shortcuts,
Ctrl+" copies the value of the cell above into the active cell. The
value I'm trying to copy is '0.0 (apostrophe+"0.0", since the sheet is
set to not display zero values, so I use the ' to make the zero value
display). The "0.0" shows up when I hit the keystroke, but disappears
as soon as I hit enter.
Is there a different keystroke for this function that will accomplish
this?
Ed
Peo Sjoblom - 08 Aug 2007 17:09 GMT
Ctrl + d
will keep the text format

Signature
Regards,
Peo Sjoblom
> I'm using XL2003. According to the Help file for Keyboard Shortcuts,
> Ctrl+" copies the value of the cell above into the active cell. The
[quoted text clipped - 7 lines]
>
> Ed
Gary''s Student - 08 Aug 2007 17:12 GMT
CNTRL-d

Signature
Gary''s Student - gsnu200736
Ed from AZ - 10 Aug 2007 16:03 GMT
And that did the trick! Thanks!!
Ed
On Aug 8, 9:12 am, Gary''s Student
<GarysStud...@discussions.microsoft.com> wrote:
> CNTRL-d
> --
> Gary''s Student - gsnu200736