Converting formula data to hard # result

I can't figure out where the command for Excel is to convert a cell that is the result of a formula to hard data. Essentially I have a cell which is the result of another cell + a %. I'm using this column in another worksheet and cannot have the original relational cell. I need this cell to keep these revised numbers but I need to remove the formula - Can you help?

Thank you.

Brian

Hi Brian,

Welcome to the forum.

To do this you need to covert the formula to a value. To do this, follow these five steps:

1. Make sure you're on the cell where the formula in question resides
2. From the Edit menu select Copy (or just press Ctrl + C)
3. From the Edit menu select Paste Special
4. From the Paste Special dialog box select (click on) the Values radio button and then click OK
5. Press the Esc keyboard button

HTH

Robert

Thank you, it resolved my issue.

Brian

I have data entered in cells and I'm wondering if there's a quick way to add "+"prior to the existing number and after to make a formula. Current cell 123 desired output. +123+280

Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread.