Looks like no one’s replied in a while. To start the conversation again, simply ask a new question.

Level 1

7 points

Copy and paste of a value in one cell to another cell without changing format of destination cell

I have a cell which is formatted in Currency format type of currency type USD. How can I copy and paste from another cell to this one cell leaving its currency format and type in place ?

Posted on May 26, 2022 11:05 PM

Best reply

Ralf-F

Level 4

2,633 points

Posted on May 26, 2022 11:53 PM

First copy you number and then insert with "Paste and Match Style" from the menu

View in context

Copy and paste of a value in one cell to another cell without changing format of destination cell

Similar questions