Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Stoad
Freaky Yak Linguist
1983 Posts |
 Posted - 2003-09-03 : 08:40:21
|
| How to copy the current number from a cell with formula intoanother cell? Without copying the formula I mean. Oh... |
|
|
mr_mist
Grunnio
1870 Posts |
Posted - 2003-09-03 : 08:47:12
|
| Copy. Then paste special - values, i believe-------Moo. :) |
 |
|
|
Stoad
Freaky Yak Linguist
1983 Posts |
Posted - 2003-09-03 : 08:56:01
|
| Oh... Now I'm disgraced forever...Thank you, Mr. Moo... |
|
|
|
Frank Kalis
Constraint Violating Yak Guru
413 Posts |
Posted - 2003-09-03 : 10:24:10
|
quote:
Originally posted by mr_mist
Copy. Then paste special - values, i believe
to piggy-back on the answer, you could 'paste special' from the menu bar, right-click on the 'new' cell or, and that's what I've done, modify the icon ?!? bar and add another icon. You'll find 'Paste special' under Command Tab->Edit-Paste SpecialCheers,Frank |
|
|
|
Frank Kalis
Constraint Violating Yak Guru
413 Posts |
Posted - 2003-09-03 : 10:26:02
|
| aaargh, too early once again.There's a special 'Paste special' icon with which you don't even need to select what should be done with the value. It inserts the copied value straight as value without formulaCheers,Frank |
|
|
|
Stoad
Freaky Yak Linguist
1983 Posts |
Posted - 2003-09-03 : 14:12:36
|
| Frank:LOL!! |
|
|
|
|
|
|
OMG. Excel.