Copying Formatted Value rather than True Value

[Lambrix]

I am sure I am about to ask yet another noob question, but I can't seem to figure out an easy solution. Is there a way to copy and paste the values as displayed by Format Cell.


I have a lot of data in the billions that I have formatted to decimals using a custom format of "$0.00,,,"

For example, it takes

"$50,450,350,230" and makes it "$50.45"

However, the problem is that when I copy and try to paste it else where I end up with the true value rather than the decimal value.

Currently I have to copy the value into notepad, and then copy it again before pasting it else where. Any ideas on a better way to accomplish this task? Thank you.

David

 

[Chris Mack]

Hi David

Perhaps use a column next to your data to actually put the data in that format, e.g., in B1:

=ROUND(A1/1000000000,2)

Hope this helps,

Chris.

 

[Lambrix]

Chris, I knew it was going to be a noob question. Thanks for the help!

 

[Chris Mack]

You're welcome!