Switching from Quattro Pro

[Bonnie]

I am switching from Quattro Pro to Excel...not too big of a difference but one function I use a
lot in Q.P. is changing formulas into data. How do I do this??? Thanks!

 

[Lady Layla]

select cell, Copy, Paste special, values


: I am switching from Quattro Pro to Excel...not too big of a difference but one
function I use a
: lot in Q.P. is changing formulas into data. How do I do this??? Thanks!

 

[Bonnie]

Thank you Thank You!!!!!!!!

 

[OM]

You should also look at what Data > Text to Columns does..... very handy
when fiddling with formulas and text.

Rob.

 

[Andy Wiggins]

Press F2 (Edit) then F9 (Calc)

--
Regards
Andy Wiggins
www.BygSoftware.com
Home of "Save and BackUp",
"The Excel Auditor" and "Byg Tools for VBA"