+ Reply to Thread
Results 1 to 28 of 28

Converting spreadsheets from inches to centimeters

  1. #1
    Registered User
    Join Date
    03-05-2018
    Location
    Toledo, OH
    MS-Off Ver
    Office 2007
    Posts
    21

    Converting spreadsheets from inches to centimeters

    I use Excel 2007 on Windows 7 Pro (64 bit), SP1. I have a spreadsheet with about 100 rows and 30 columns; i.e., 3000 data cells. Data is manually entered into the data cells, using 'inches' as the measurement system. There are also about 10 columns of summation results. This spreadsheet uses the Table format. There are several pages of linked Charts that are created based on this data.

    I have a friend who wants this information in centimeters. All the methods I knew of (using Convert, etc.) required having additional cells, which is a major task.

    JE McGimpsey suggested one way in a 2005 thread, "Convert my entire spreadsheet from inches to centimeters". But that thread appears to be closed.

    He said: "Enter 2.54 in an empty cell. Copy the cell. Select your values to
    convert. Choose Edit/Paste Special, selecting the Values and Multiply
    radio buttons."

    So I cloned my original spreadsheet onto a new tab, and used his procedure to quickly populate the new spreadsheet with centimeter dimensions. That worked great.

    But there was a problem. I have many empty cells. Sometimes no data was taken on a day, or data was missed at a specific time. My original spreadsheet, and the cloned spreadsheet display those cells as being empty. But in the cloned spreadsheet, his method actually has a 'hidden' 0(zero) in each of the supposedly empty cells. You can only see that 0 if you click on the specific cell.

    For some tasks that might not be a problem. But I have multiple charts that use the data on the cloned spreadsheet. So initially those charts displayed all supposedly empty cells as a 0, rather than ignoring them. To fix the problem, I had to click on every cell which appeared to be empty, and if it contained a 0, delete it.

    Does anyone know why his method creates this 0, and if there is some way I can modify his procedure to make sure that cells which display as empty are really empty?


    Harry

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,335

    Re: Converting spreadsheets from inches to centimeters

    Will you please attach a sample Excel workbook? We are not able to work with or manipulate a picture of one and nobody wants to have to recreate your data from scratch.

    1. Make sure that your sample data are REPRESENTATIVE of your real data. The use of unrepresentative data is very frustrating and can lead to long delays in reaching a solution.

    2. Make sure that your desired results are also shown (mock up the results manually).

    3. Make sure that all confidential data is removed or replaced with dummy data first (e.g. names, addresses, E-mails, etc.).

    4. Try to avoid using merged cells as they cause lots of problems.

    Unfortunately the attachment icon doesn't work at the moment, so to attach an Excel file you have to do the following: just before posting, scroll down to Go Advanced and then scroll down to Manage Attachments. Now follow the instructions at the top of that screen.

    Please pay particular attention to point 2 (above): without an idea of your intended outcomes, it is often very difficult to offer appropriate advice.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

  3. #3
    Forum Expert kersplash's Avatar
    Join Date
    11-22-2016
    Location
    Perth
    MS-Off Ver
    Home 2016 (Windows 10)/Work 2013 Pro Plus (Windows 10)
    Posts
    2,012

    Re: Converting spreadsheets from inches to centimeters

    Quote Originally Posted by bex1210 View Post
    All the methods I knew of (using Convert, etc.) required having additional cells, which is a major task.
    Why is having additional cells a major task?

    Attach a sample of your data showing what you want to achieve mocked-up.

    Go Advanced -> Manage Attachments -> Upload

  4. #4
    Registered User
    Join Date
    03-05-2018
    Location
    Toledo, OH
    MS-Off Ver
    Office 2007
    Posts
    21

    Re: Converting spreadsheets from inches to centimeters

    I already have 3000 data cells. Using 'Convert' or simple multiplication requires an empty cell for EACH of the cells I want to convert, or 3000 more cells. The procedure McGimpsey suggested only requires one extra cell.

    The moderator, AliGW, said I need to attach a complete, non proprietary spreadsheet. That will take me a day or so to create.

    Harry

  5. #5
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,335

    Re: Converting spreadsheets from inches to centimeters

    Providing a workbook is optional, however it will make helping you a lot easier. It might be the difference between getting help and not getting help. Up to you!

  6. #6
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: Converting spreadsheets from inches to centimeters

    We only need a SMALL sample of what you are working with, maybe 10-20 rows. Just enough to show what you are working with.
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  7. #7
    Forum Expert
    Join Date
    03-20-2015
    Location
    Primarily UK, sometimes NL
    MS-Off Ver
    Work: Office 365 / Home: Office 2010
    Posts
    2,404

    Re: Converting spreadsheets from inches to centimeters

    Quote Originally Posted by bex1210 View Post
    Data is manually entered into the data cells, using 'inches' as the measurement system. There are also about 10 columns of summation results.
    I assume from this that it's only the manually entered data which needs to be converted to centimetres - the rest will automatically calculate.

    Quote Originally Posted by bex1210 View Post
    "Enter 2.54 in an empty cell. Copy the cell. Select your values to convert. Choose Edit/Paste Special, selecting the Values and Multiply radio buttons."
    It's this 'select your values' part which you want to work on. Based on the assumption above, all the manually entered data is constants. Assuming that that's correct and that there aren't any other numerical constants mixed in with that data, you just need to select only constants in your range. So try this:

    Enter 2.54 in a spare cell and copy it.
    Select the range containing this manually entered data.
    Press F5 to open the Go To dialogue box then click Special.
    Select Constants and click OK. Now only the manually entered data should be selected.
    Now use Paste Special and Multiply.

    Make sure you try this first on a copy of the file/sheet, just in case the assumption above turns out not to be true!
    Regards,
    Aardigspook

    I recently started a new job so am a bit busy and may not reply quickly. Sorry - it's not personal - I will reply eventually.
    If your problem is solved, please go to 'Thread Tools' above your first post and 'Mark this Thread as Solved'.
    If you use commas as your decimal separator (1,23 instead of 1.23) then please replace commas with semi-colons in your formulae.
    You don't need to give me rep if I helped, but a thank-you is nice.

  8. #8
    Registered User
    Join Date
    03-05-2018
    Location
    Toledo, OH
    MS-Off Ver
    Office 2007
    Posts
    21

    Re: Converting spreadsheets from inches to centimeters

    AliGW:

    Thanks for the detailed help about how to attach files. I hope I did it correctly.

    And thanks for suggesting that I just create a simplified spreadsheet. However in this
    case, it takes much more work to create one than to just remove all text that might in
    some way be confidential, so that is what I did.

    I will not repeat my setup and the problem, which are listed in my 1st post.

    Two files are attached. The first contains the 'Paste Special' windows that
    JE McGimpsey suggested. You will see that I checked the two items that he suggested:
    Values and Multiply. There is also a 'Skip Blanks' option. I tried both checking this
    option and leaving it unchecked. That option had no effect on the problem I have.

    The second file is the Excel spreadsheet. It should open to the 1st Tab, 'Measurements'.
    Rows 16 thru 119 are data rows, where data (in inches) is entered manually.
    (This is a Table. I have hidden row 15, which is the Table header row.) For each of the
    rows, data is entered in columns B thru S, and V thru AM. (Columns AP thru AU are
    calculated, based on the manually entered data.) There are several blank rows
    representing missed dates (line 104 represents multiple missed dates), and other rows
    just have a few blank cells that were missed. If you click on any of these blank cells,
    you will see that they are empty.

    The 2nd Tab is 'Charts'. I actually have about 40 linked charts, but I simplified this
    file to only include 2 of them. The top one, 'Left Foot-Front', consists of columns A
    thru D, the bottom one, 'Left Ankle-Below Bone', consists of column A, and columns E
    thru G. Both charts contain values in the 9 to 11 inch range.

    The 3rd tab is 'MeasurementsCm'. I entered 2.54 in Cell N1, and copied it to Rows 16
    thru 119, columns B thru S, and V thru AM. Then I selected the Values and Multiply
    radio buttons in the Paste Special window. Click on any of the blank cells. You will
    see that they are not empty, but contain 0 (zero).

    Now look at the 'ChartsCm' tab. You will see that not only are there values in the 25
    to 30 Cm range, but each entry also has a 0 value! The first row with a 0 value on the
    charts is row 18, 7/24/2018. Click on B18, C18, & D18, and delete the 0 values. Now
    look at the 'Left Foot-Front' chart. 7/24/2018 no longer displays the 0 value!

    So my question is: How do I prevent the 0 value from appearing in the blank cells of the
    'MeasurementsCm' tab? They should be empty, like the blank cells on the 'Measurements'
    tab.


    Harry
    Attached Images Attached Images
    Attached Files Attached Files

  9. #9
    Registered User
    Join Date
    03-05-2018
    Location
    Toledo, OH
    MS-Off Ver
    Office 2007
    Posts
    21

    Re: Converting spreadsheets from inches to centimeters

    Quote Originally Posted by Aardigspook View Post
    I assume from this that it's only the manually entered data which needs to be converted to centimetres - the rest will automatically calculate.
    Yes, you are correct. The other columns calculate automatically.

    It's this 'select your values' part which you want to work on. Based on the assumption above, all the manually entered data is constants. Assuming that that's correct and that there aren't any other numerical constants mixed in with that data, you just need to select only constants in your range. So try this:

    Enter 2.54 in a spare cell and copy it.
    Select the range containing this manually entered data.
    Press F5 to open the Go To dialogue box then click Special.
    Select Constants and click OK. Now only the manually entered data should be selected.
    Now use Paste Special and Multiply.

    Make sure you try this first on a copy of the file/sheet, just in case the assumption above turns out not to be true!
    No other constants are mixed in with the data--numerical or otherwise.

    This DOES work. [Don't worry, I tried it on a copy.] But as you noted, the conditions have to be very specific for it to work. What I really don't understand is why this step is necessary: i.e., why the 0 (zero) is created in the 1st place.

    Look at the post I made less than an hour ago addressed to AliGW, where I provide more details and a copy of the spreadsheet.


    Harry

  10. #10
    Forum Expert
    Join Date
    03-20-2015
    Location
    Primarily UK, sometimes NL
    MS-Off Ver
    Work: Office 365 / Home: Office 2010
    Posts
    2,404

    Re: Converting spreadsheets from inches to centimeters

    The 0 is created because doing Paste Special → Multiply tells Excel to multiply all selected values by 2.54. Unfortunately, the way the function is programmed into Excel means that it treats blanks as zeroes, so the result becomes 0 (0 x 2.54). The only way I know of, without VBA, to avoid that is to exclude the blanks from the selection before doing the multiplication, by selecting only the other data.

  11. #11
    Registered User
    Join Date
    03-05-2018
    Location
    Toledo, OH
    MS-Off Ver
    Office 2007
    Posts
    21

    Re: Converting spreadsheets from inches to centimeters

    Quote Originally Posted by Aardigspook View Post
    The 0 is created because doing Paste Special → Multiply tells Excel to multiply all selected values by 2.54. Unfortunately, the way the function is programmed into Excel means that it treats blanks as zeroes, so the result becomes 0 (0 x 2.54). The only way I know of, without VBA, to avoid that is to exclude the blanks from the selection before doing the multiplication, by selecting only the other data.
    OK, I can follow what Excel has done. But if that is the way it is programmed, why doesn't checking the 'Skip blanks' option in the Paste Special window solve the problem?


    Harry

  12. #12
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Converting spreadsheets from inches to centimeters

    ...back to the Q. Kersplash asked seemingly ages ago.
    Why are a parallel set of problems out of the question?

    If you don't need them after you've multipled by 2.4 just copy them all, paste as values over the original columns and delete the helper columns.
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  13. #13
    Registered User
    Join Date
    03-05-2018
    Location
    Toledo, OH
    MS-Off Ver
    Office 2007
    Posts
    21

    Re: Converting spreadsheets from inches to centimeters

    Quote Originally Posted by Richard Buttrey View Post
    ...back to the Q. Kersplash asked seemingly ages ago.
    Why are a parallel set of problems out of the question?

    If you don't need them after you've multipled by 2.4 just copy them all, paste as values over the original columns and delete the helper columns.
    This was my answer to Kersplash earlier:
    I already have 3000 data cells. Using 'Convert' or simple multiplication requires an empty cell for EACH of the cells I want to convert, or 3000 more cells. The procedure McGimpsey suggested only requires one extra cell.

    In my case it is easier to manually delete the '0' values than to create and remove all the extra data cells.

    There are multiple ways to fix the problem, including what Aardigspook suggested, but each have certain limitations. I am trying to see if there is a way to prevent the problem from occurring at all.


    Harry

  14. #14
    Forum Expert
    Join Date
    12-11-2011
    Location
    Netherlands
    MS-Off Ver
    office 365
    Posts
    3,255

    Re: Converting spreadsheets from inches to centimeters

    Does anyone know why his method creates this 0, and if there is some way I can modify his procedure to make sure that cells which display as empty are really empty?
    With CTR H you can remove all the zero's
    Willem
    English is not my native language sorry for errors
    Please correct me if I'm completely wrong

  15. #15
    Registered User
    Join Date
    03-05-2018
    Location
    Toledo, OH
    MS-Off Ver
    Office 2007
    Posts
    21

    Re: Converting spreadsheets from inches to centimeters

    Quote Originally Posted by popipipo View Post
    With CTRL H you can remove all the zero's
    That is quicker and more foolproof than doing it manually, as long as 'Match entire cell contents' is checked.

    I had not thought of that option. Thanks. Or course I would still prefer that it not happen to begin with!


    Harry

  16. #16
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Converting spreadsheets from inches to centimeters

    Quote Originally Posted by bex1210 View Post
    This was my answer to Kersplash earlier:
    I already have 3000 data cells. Using 'Convert' or simple multiplication requires an empty cell for EACH of the cells I want to convert, or 3000 more cells. The procedure McGimpsey suggested only requires one extra cell.

    In my case it is easier to manually delete the '0' values than to create and remove all the extra data cells.

    There are multiple ways to fix the problem, including what Aardigspook suggested, but each have certain limitations. I am trying to see if there is a way to prevent the problem from occurring at all.


    Harry
    Stating the obvious but since the data is being entered manually in inches, the only way to "prevent the problem occurring at all" is to stop enetreing in inches and enter in cm.

    Otherwise you will necessarily have to 'do' something or other. I don't see why helper columns are too onerous. A simple =A1*2.54 copied down 3000 rows and across columns takes only a few seconds. Then a Quick selection of all cells and a Find for zero and Replace with null will achieve what you want.

    Better still is Aardigspook's solution. Why is that a limitation given that you will have to perform some action or another?

  17. #17
    Registered User
    Join Date
    10-28-2008
    Location
    Turkey
    Posts
    88

    Re: Converting spreadsheets from inches to centimeters

    .

    I think CONVERT function is better.

    Look at this file.
    Attached Files Attached Files

  18. #18
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,335

    Re: Converting spreadsheets from inches to centimeters

    Sorry for off-topic interjection:

    Although there is no official rule regarding this behaviour, we request that wherever possible both the question AND the answer be provided in substantive detail here within the thread. An attached workbook is an excellent aid for posing a question and offering a solution, but solely doing that with no in thread explanation makes it difficult for researchers to understand or consider the Q & A of this thread without downloading what may be a pointless doc to them, if they can do that at all. Doing that also hides the content from search engines so others may never benefit from this.

  19. #19
    Registered User
    Join Date
    10-28-2008
    Location
    Turkey
    Posts
    88

    Re: Converting spreadsheets from inches to centimeters

    Quote Originally Posted by AliGW View Post
    Sorry for off-topic interjection:

    Although there is no official rule regarding this behaviour, we request that wherever possible both the question AND the answer be provided in substantive detail here within the thread. An attached workbook is an excellent aid for posing a question and offering a solution, but solely doing that with no in thread explanation makes it difficult for researchers to understand or consider the Q & A of this thread without downloading what may be a pointless doc to them, if they can do that at all. Doing that also hides the content from search engines so others may never benefit from this.
    Dear AliGW,
    Your comments, are for my answer? If that's what I've done I need to explain. The subject came to me simple. Or misunderstood. I think, it is not difficult to use the Convert function. What kind of explanation would I make?

    Respects.

  20. #20
    Registered User
    Join Date
    03-05-2018
    Location
    Toledo, OH
    MS-Off Ver
    Office 2007
    Posts
    21

    Re: Converting spreadsheets from inches to centimeters

    Quote Originally Posted by yurttas View Post
    .

    I think CONVERT function is better.

    Look at this file.
    I downloaded your file. The results look fine when viewing just the spreadsheet. I renamed the file you created to Forum_ExcelTrial_LegMeasurementTest.xlsx so it is not confused with the original I uploaded. I renamed your tab from MeasurementsCm (2) to MeasurementsCm2. For example, in cell D18, this is the formula you entered: =CONVERT(Measurements!D18,"in","m")*100.

    Unfortunately, you did not create a Chart. The problem still exists, but you cannot see it on the spreadsheet. So I created another tab, ChartsCm2. I have attached Forum_ExcelTrial_LegMeasurementTest_withCharts.xlsx.

    If you look at the Charts, you will see that on all the dates that do not have numerical entries, a '0' is plotted. I tried to solve the problem by deleting all the CONVERT formulas, but even after deleting them, the '0' still plots on the Charts. I have no idea why.


    Of all the suggestions, for my situation, the Aardigspook solution is easiest. But it only works for certain conditions.

    It appears the Excel created this problem, and some form of workaround is required.


    Harry

  21. #21
    Registered User
    Join Date
    03-05-2018
    Location
    Toledo, OH
    MS-Off Ver
    Office 2007
    Posts
    21

    Re: Converting spreadsheets from inches to centimeters

    Quote Originally Posted by Richard Buttrey View Post
    Stating the obvious but since the data is being entered manually in inches, the only way to "prevent the problem occurring at all" is to stop entering in inches and enter in cm.
    In a perfect world, you are correct. But in my case there is no reason to have everyone stop measuring in inches just for a non-participant who is more used to using centimeters.

    Otherwise you will necessarily have to 'do' something or other. I don't see why helper columns are too onerous. A simple =A1*2.54 copied down 3000 rows and across columns takes only a few seconds. Then a Quick selection of all cells and a Find for zero and Replace with null will achieve what you want.
    That is the Mcgimpsey solution. I was just looking for something that saved that 2nd step.

    Better still is Aardigspook's solution. Why is that a limitation given that you will have to perform some action or another?
    I agree, and that is what I am using. Too bad that Excel created the problem!


    Harry

  22. #22
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Converting spreadsheets from inches to centimeters

    Quote Originally Posted by bex1210 View Post
    That is the Mcgimpsey solution. I was just looking for something that saved that 2nd step.


    Harry
    You could of course get a macro to do it for you at the click of a button so that there is no 2nd, or even first step.

  23. #23
    Registered User
    Join Date
    03-05-2018
    Location
    Toledo, OH
    MS-Off Ver
    Office 2007
    Posts
    21

    Re: Converting spreadsheets from inches to centimeters

    Quote Originally Posted by Richard Buttrey View Post
    You could of course get a macro to do it for you at the click of a button so that there is no 2nd, or even first step.
    You are absolutely correct. Unfortunately, my skill set does not include writing Excel macros.


    Harry

  24. #24
    Forum Expert
    Join Date
    03-20-2015
    Location
    Primarily UK, sometimes NL
    MS-Off Ver
    Work: Office 365 / Home: Office 2010
    Posts
    2,404

    Re: Converting spreadsheets from inches to centimeters

    If this is something you need to keep constantly updated, then changing your formulae in the 'cm' sheet will be a better way to go.

    Use this for column A (dates):
    Formula: copy to clipboard
    Please Login or Register  to view this content.



    Use this sort of formula for the 'data' columns (B-S and V-AM):
    =IF( ISNUMBER( cell in inches sheet ), cell in inches sheet * 2.54 , #N/A )

    So, you can enter this in B16 and drag across using right-click – drag – select 'fill without formatting':
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    Depending on your Table settings, it may auto-populate down - if not then drag down in the same way.

    In V16, use this, then drag across in the same way (and down if needed):
    Formula: copy to clipboard
    Please Login or Register  to view this content.



    For the calculated columns, add an error check, like this:
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    Amend/drag as necessary for the other columns.

    Then, expand the table down to ensure that it auto-fills when the inches table is filled in (using the little black triangle at the bottom-right of the bottom-right cell of the Table) - an extra couple of hundred rows shouldn't slow it down noticeably.


    Using #N/A as the 'if false' argument makes the charts ignore those cells.
    The disadvantage of this is that your table does get filled up with cells with #N/A, which can be a bit distracting. Personally, I would then 'fade' those using Conditional Formatting, with this rule applied to the range $A$16:$AU$270:
    Formula: copy to clipboard
    Please Login or Register  to view this content.



    Attached is a file with this working. Hope it helps a bit.

  25. #25
    Registered User
    Join Date
    03-05-2018
    Location
    Toledo, OH
    MS-Off Ver
    Office 2007
    Posts
    21

    Re: Converting spreadsheets from inches to centimeters

    Quote Originally Posted by Aardigspook View Post
    If this is something you need to keep constantly updated, then changing your formulae in the 'cm' sheet will be a better way to go.
    WOW! That is great work. I don't have the skills to create those formulas, so I really appreciate not only the sample spreadsheet, but also the text that explained what you did and how to apply it.

    I will have to update my spreadsheet a few times, but hopefully then the person that now wants the Centimeters will no longer need to see the results.

    What I don't understand is why you had to add all the extra rows in 'MeasurementsCm'? Since this is a Table, when I enter a new date on the 'Measurements' tab at the bottom of column A (A120 in this case) and then add a number in B120, shouldn't A120 & B120 on the 'MeasurementsCm' tab automatically populate with the correct date & number? I took off the Protection and inserted a new 'blank' row after row 119 on the MeasurmentsCm tab, and it worked just fine.


    Harry

  26. #26
    Forum Expert
    Join Date
    03-20-2015
    Location
    Primarily UK, sometimes NL
    MS-Off Ver
    Work: Office 365 / Home: Office 2010
    Posts
    2,404

    Re: Converting spreadsheets from inches to centimeters

    Quote Originally Posted by bex1210 View Post
    What I don't understand is why you had to add all the extra rows ...
    I ... inserted a new 'blank' row after row 119 on the MeasurmentsCm tab, and it worked just fine.
    The reason I suggested adding a few new rows is so that you don't need to do this last step. If you prefer just to add new rows as you add data, that's no problem. Either way works.


    I'm glad we were able to help - get back to us if you have further questions.
    Alternatively, if that takes care of your question, then please take a moment to mark the thread as Solved so others know there's an answer here (instructions are in my sig). Please also consider thanking anyone who helped you by clicking * Add Reputation under the post which helped. Thanks.

  27. #27
    Registered User
    Join Date
    03-05-2018
    Location
    Toledo, OH
    MS-Off Ver
    Office 2007
    Posts
    21

    Re: Converting spreadsheets from inches to centimeters

    Quote Originally Posted by Aardigspook View Post
    I'm glad we were able to help - get back to us if you have further questions.
    I have no other questions. The folks who took the time to address my problem on this thread have ben great.

    Alternatively, if that takes care of your question, then please take a moment to mark the thread as Solved so others know there's an answer here (instructions are in my sig). Please also consider thanking anyone who helped you by clicking * Add Reputation under the post which helped. Thanks.
    I have marked it as Solved, and clicked 'Add Reputation' to the posts that were of most help. I also gave the post an Excellent rating based on the help I got.


    Harry

  28. #28
    Forum Expert
    Join Date
    03-20-2015
    Location
    Primarily UK, sometimes NL
    MS-Off Ver
    Work: Office 365 / Home: Office 2010
    Posts
    2,404

    Re: Converting spreadsheets from inches to centimeters

    Again, glad we could help - a team effort. Thanks for the feedback and for the rep.

+ 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. Converting Feet & Inches to Decimal Inches
    By knavarro01 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-29-2016, 02:50 PM
  2. Conerting Inches to centimeters
    By AragornAdvert in forum Excel General
    Replies: 2
    Last Post: 06-18-2008, 07:41 PM
  3. Centimeters to inches formula!
    By rageon75 in forum Excel - New Users/Basics
    Replies: 6
    Last Post: 08-11-2006, 08:00 PM
  4. [SOLVED] Convert cubic centimeters to fluid ounces and cubic centimeters
    By OcalaElaine in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 06-14-2006, 01:50 PM
  5. Change measurements from inches to centimeters in EXCEL 2002?
    By MaggieBrennan in forum Excel General
    Replies: 0
    Last Post: 05-25-2005, 05:31 AM
  6. Replies: 4
    Last Post: 05-03-2005, 10:06 AM
  7. [SOLVED] Convert my entire spreadsheet from inches to centimeters
    By Ted in forum Excel General
    Replies: 1
    Last Post: 04-27-2005, 01:06 PM

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