Results 1 to 7 of 7
  1. #1
    3 Star Lounger
    Join Date
    Jul 2001
    Location
    Long Beach, California, USA
    Posts
    233
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Cable Sizes_Electrical (2002/2003)

    I have an electrician who asked me how he could enter either of two cable sizes into a cell. When he enters 3/0 or 4/0 into a cell, Excel interputs those values as a date. Off the top of my head I told him to enter '3/0 into the cell so that Excel will display 3/0.

    Is there another way to enter these values or is this it?

    Thanks in advance.

    Brent

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Cable Sizes_Electrical (2002/2003)

    Another option would be to format the column or columns in which cable sizes will be entered as text.

  3. #3
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Cable Sizes_Electrical (2002/2003)

    If you format the cell as Text BEFORE entering the value, that will also work. However, once you enter it and Excel has made it into a date, changing the format will not change it into text.
    Legare Coleman

  4. #4
    Silver Lounger t8ntlikly's Avatar
    Join Date
    Dec 2001
    Location
    Chandler, AZ
    Posts
    2,162
    Thanks
    46
    Thanked 13 Times in 11 Posts

    Re: Cable Sizes_Electrical (2002/2003)

    OR! you can PRE format the cell using the Custom in Format to read 0 "/" 0 <please note space between the 0 and the " marks.. when you enter in 32 it will then read 3/2 if you want to multiply it say by 2, then the cell you multiply it in should also be formatted and it will read 6/4
    Thanks John
    Teamwork is essential; it gives the enemy other people to shoot at. (Murphy's War Laws #39)

  5. #5
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Cable Sizes_Electrical (2002/2003)

    True, but since it is extremely unlikely that anyone would want to do math with the cable size, there little to no reason to have it as a numeric value. And, if there is a cable size of 10/0, your format method will not work very well. One other thing. In at least some older versions of Excel (XL2K which I run since it does not have the Registration/Activation Wizard) there is a fairly low limit to the number of custom formats that you can define, and this would use up one for little or no benefit.
    Legare Coleman

  6. #6
    3 Star Lounger
    Join Date
    Jul 2001
    Location
    Long Beach, California, USA
    Posts
    233
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Cable Sizes_Electrical (2002/2003)

    Thanks Hans, Legare, and T8nt. The folks here are always willing to help out and share knowledge. I appreciate it.

  7. #7
    Silver Lounger t8ntlikly's Avatar
    Join Date
    Dec 2001
    Location
    Chandler, AZ
    Posts
    2,162
    Thanks
    46
    Thanked 13 Times in 11 Posts

    Re: Cable Sizes_Electrical (2002/2003)

    Legare,
    I agree that there may be no need to do math with cable sizes, this is just another way of doing what he wants. True using '10/0 is faster.
    I formatted a cell using 0 "/" 0 and entered in 100 and it showed up as 10/0. Once you get over 999 with mine however you run into trouble.
    I looked at a PC that has Office 2K, one that has Office XP, one that has Office '03, and of course mine which has Office '07. They all appear to have about the same number of Customs in them. How many you can actually define is something I don't know and wouldn't even want to quess at. What I do know, is that the Custom is only saved to the workbook and worksheets within that workbook when you save and close it. If you open a new workbook, the Custom is not there.
    This is just another example of what Excel and Office in general is truly capable of and why it intrigues me to the point that I am going through the the Microsoft Office Specialist training. Hopefully one day I will be as proficient in Office as you and a lot of others in here.
    Thanks for the feedback.
    Thanks John
    Teamwork is essential; it gives the enemy other people to shoot at. (Murphy's War Laws #39)

Posting Permissions

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