Cell Formats

[BobH]

I use a spreadsheet to track (and verify) my electricity usage and billing. I have a smart meter and can access the database that is updated on weekdays; so I can see usage as it accretes and project what charges will be for the billing period.

I've noticed that when I copy data from the database and paste it into my spreadsheet, that the cell formatting from the database results rather than the formatting I'd prefer. I want to see KWH to 3 decimal points.

Is there a way to preserve my column formatting while copying data into those columns?

[HansV]

Copy the data in the database.
Select the (first) target cell.
Click the lower half of the Paste button on the Home tab of the ribbon.
Select 'Match Destination Formatting' or press M.

S0869.png

[StuartR]

Alternatively you can right click the target cell and use Paste Values to paste just the value of the copied data, and not the formatting.

[BobH]

I knew there had to be an answer.

Thank you, Gentlemen!!!

[HansV]

@StuartR: the options in your screenshot are available when you copy/paste within Excel. If the clipboard contains external data (from a database for example), the options are as shown in my screenshot.

[StuartR]

Thanks for the correction Hans

[SpeakEasy]

>the options are as shown in my screenshot

To be fair, that really rather depends on what formats the source application makes available on the clipboard

[HansV]

Thanks!