0

Is it possible to copy/paste only number formatting in Excel.

There are various paste special options.

In particular Formulas/Number Formats and Values/Number Formats. But is there a way to paste only the number formatting?

Often, I’ll already have values/formats that I don’t want to paste over. And it’s just the custom number formatting I want to change.

I know you can do it in VBA, but I’m looking for a non-VBA solution or confirmation that there isn’t one.

————

Apparently I wasn’t clear enough.

I want to paste only the number formatting. No fonts, no colours, no borders. No other formatting of any kind.

So no paste special -> format. No format painter. Nothing that would over-ride what’s already there.

Improve this question
8
  • There are a number of ways to past value only, but the easiest is to format the cell range into which you wish to copy as numeric only. Define the number format for the columns or rows with the format you wish, including number of decimal places, thousands separator and color for negative values.
    – DrMoishe Pippik
    Commented Jul 23, 2023 at 23:53
  • (after copy) r-click > paste special > formatting | ref : support.microsoft.com/en-us/office/…
    – p._phidot_
    Commented Jul 24, 2023 at 2:36
  • @p._phidot_ I specifically do not want to copy any other formatting. Just the number formats.
    – Kaz
    Commented Jul 24, 2023 at 3:47
  • hurm.. tried "Shortcuts for number formats" ? [ref : exceljet.net/articles/custom-number-formats ]
    – p._phidot_
    Commented Jul 24, 2023 at 4:33
  • 1
    Should u had found a suitable way to do it.. Hope u didn't mind to share.. (I'm all ears..)
    – p._phidot_
    Commented Oct 18, 2023 at 17:01

0

Reset to default

You must log in to answer this question.