+ Reply to Thread
Results 1 to 4 of 4

Units Used In Excel Sheets.

  1. #1
    Registered User
    Join Date
    12-15-2016
    Location
    Sydney, Australia
    MS-Off Ver
    Home & Business 2010
    Posts
    2

    Units Used In Excel Sheets.

    Hi,
    I have been using excel on and off for a long time and because I chop sheets from 1 work book to another, I have ended up with the following problem.
    I have work books in which the units used from sheet to sheet vary.
    The width of a column on one sheet may be in inches whilst in the sheet after the column widths are in a decimal format.
    Is there any way to change the work book so all sheets use the same units for all sheets?
    Many thanks

  2. #2
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2019 Professional Plus - 2007 Enterprise
    Posts
    7,009

    Re: Units Used In Excel Sheets.

    You can copy and paste ... or you can copy and paste: values & formats

    Please Login or Register  to view this content.
    I can't vouch for this tool but it seems like a winner: https://www.excelcampus.com/tools/format-copier/
    Last edited by Logit; 12-15-2016 at 09:11 PM.

  3. #3
    Registered User
    Join Date
    12-15-2016
    Location
    Sydney, Australia
    MS-Off Ver
    Home & Business 2010
    Posts
    2

    Re: Units Used In Excel Sheets.

    Thankyou very much, I will give it a go.

  4. #4
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2019 Professional Plus - 2007 Enterprise
    Posts
    7,009

    Re: Units Used In Excel Sheets.

    Your welcome.

    Merry Christmas !

+ 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. Convert units and units of measure
    By AntiPivotTable in forum Excel General
    Replies: 1
    Last Post: 10-21-2016, 07:22 PM
  2. [SOLVED] Formula to determine number of units at each location and status of units
    By Klimer in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 08-18-2016, 10:01 AM
  3. Trying to do conditional counting, units within units
    By Butcher1 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 03-17-2016, 01:01 PM
  4. Replies: 1
    Last Post: 05-31-2013, 11:45 AM
  5. [SOLVED] Calculate the Bonus units according to the quantity of the units bought (Help)
    By mo_naf in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 09-15-2012, 05:51 PM
  6. Set the Ruler Units in Excel 2007
    By ExcelTip in forum Tips and Tutorials
    Replies: 0
    Last Post: 11-13-2007, 04:19 AM
  7. can I put units in MS excel like 200 mm in formulae ?
    By Prashant in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-30-2006, 10:25 AM

Tags for this Thread

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