+ Reply to Thread
Results 1 to 3 of 3

Copy Custom Number Format to other spreadsheets

  1. #1
    Registered User
    Join Date
    03-05-2015
    Location
    Bury St Edunds
    MS-Off Ver
    Office 2013
    Posts
    9

    Copy Custom Number Format to other spreadsheets

    I have a custom number formant which I need to apply to a number of spreadsheets.

    Is there a easy way I can apply this to all spreadsheets; at the moment I have to go into each one and retype the entry in the custom format box.

  2. #2
    Forum Expert bebo021999's Avatar
    Join Date
    07-22-2011
    Location
    Vietnam
    MS-Off Ver
    Excel 2016
    Posts
    9,463

    Re: Copy Custom Number Format to other spreadsheets

    Just copy then paste special/format; to destination cells.
    Quang PT

  3. #3
    Registered User
    Join Date
    03-05-2015
    Location
    Bury St Edunds
    MS-Off Ver
    Office 2013
    Posts
    9

    Re: Copy Custom Number Format to other spreadsheets

    Nearly every spreadsheet we use has a certain number format* - at the moment I copy and paste from one spread sheet to another - I'd like it so that it's automatically available in any spreadsheet that I open

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Copy paste of Excel custom number format into Powerpoint doesn't work
    By Philipp83 in forum PowerPoint Formatting & General
    Replies: 3
    Last Post: 03-28-2021, 01:03 PM
  2. Replies: 5
    Last Post: 01-25-2020, 05:18 PM
  3. Replies: 6
    Last Post: 12-08-2018, 09:26 PM
  4. Need formula or code to convert number(s) from custom format to number format
    By tuongtu3 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 01-12-2015, 07:44 PM
  5. how do I add phone number format as a permanent custom format?
    By frustratedagain in forum Excel General
    Replies: 3
    Last Post: 02-03-2006, 11:52 PM
  6. Format a cell with a custom number format
    By Armor in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-29-2006, 07:30 PM
  7. Custom number format always defaults last number to 0.
    By scubadave in forum Excel General
    Replies: 2
    Last Post: 06-15-2005, 06:05 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1