Keyboard shortcut won't copy zero text value?

E

Ed from AZ

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
 

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

Top