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!! |
|
|
|
|
|