Yes, there is a way to copy the formatted value and paste it as a new value in Excel. Here are the steps:
- Select the cell(s) containing the formatted value(s) that you want to copy.
- Right-click on the selected cell(s) and choose "Copy" or press "Ctrl+C" on your keyboard.
- Right-click on a different cell where you want to paste the new value(s) and choose "Paste Special" or press "Ctrl+Alt+V" on your keyboard.
- In the "Paste Special" dialog box, select "Values" under "Paste" and select the desired format under "Operation" (e.g. "Add", "Subtract", "Multiply", "Divide", etc.).
- Click "OK" to paste the new value(s) with the desired format.
Note that this method will only work if the original value(s) have been formatted using Excel's built-in number or date formats. If the original value(s) have been formatted using custom formats or formulas, this method may not work as expected. In that case, you may need to re-enter the value(s) with the desired format.