Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Entering Cable sizes.

Entering Cable sizes.

Entering Cable sizes.

I have been copying cable sizes from one one data base ( Access) to Excell and it works for everything but "ought" size cables.  If I copy a size 4/0 cable it comes out in excell as Apr-00, if I reformat the cell it becomes 36617.
I know if I put an ' in front of the 4/0 will show up just fine.  I am sure there is a way to make it show up as $/0 but haven't stumbled on it yet.
Is there a way to make it happen?
Replies continue below

Recommended for you

RE: Entering Cable sizes.

Can you specify the cell(s) in which you are going to be copying the data to from Access as text in Excel (format, cells, number tag and then 'text' option)?  That's what you are doing with the ' sign essentially.

RE: Entering Cable sizes.

While Paste Special->Text work?

RE: Entering Cable sizes.

i had in the past prepared cable lists and stumbled on the same thing...
the solution we adopted was...
format the whole column as text
right justify (so the numbers start from the right end of the cell and not the left as text)
use the following convention for the big cables:
0000 <- your 4/0  which is in reality what it means... 4/0 is short for 0000 (four zeroes)


RE: Entering Cable sizes.

Thanks to all.  I had tried all those solutions - i just thought there might be an easier way.  
If I copy a an area that is 12 columns wide with with 40 or 50 rows it copys text, numbers, etc correctly but not the 2/0, 3/0 etc.   It seem like those characters are the only ones that I have to specifically format a row for.  Not a big problem, I just thought I was missing an obvious trick.

Thanks to all again.

RE: Entering Cable sizes.

If you are copying the entire table or contiguous portions of it, you can export directly from Access to Excel. The X/0 entries will show up as text, no work necessary on your part.

If you are copying to an existing Excel workbook, this method won't be of much use.

RE: Entering Cable sizes.

Every time that you digit or paste a field that include the right slash ("/") in a a cell, you have problems whit a intrinsic tendency of EXEL to assume it is a date.
Few month ago, was publishied a smart trick that suggested digit SPACE as first entry.It works!

RE: Entering Cable sizes.

I think I solved the problem I was having.
The data I was working with was in 47 columns. when I copied the cable sizes ( and the data in the other 46 colums) to Excel the cable sizes showed up as dates.  # 4/0 being Apr-00 etc. I am only using about 6 of the colums so I copy them to another section of the spreadsheet where they eventually get pasted on to a drawing.
I used some nested if statement which work because there are only four "naught" size cables.


K2 is the cell where the cable size in one of the 47 pasted columns is located, the if statement  is in the cell where I want to copy it.   The numbers 36586 are the serial numbers for April 1, 2000 etc.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members! Already a Member? Login


Close Box

Join Eng-Tips® Today!

Join your peers on the Internet's largest technical engineering professional community.
It's easy to join and it's free.

Here's Why Members Love Eng-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close