Entering Cable sizes.

• Feb 13, 2004

• #2

TD2K

Chemical

Jan 11, 2002

2,629

US

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.

 

Upvote 0 Downvote

• Feb 13, 2004

• #3

melone

Electrical

Aug 10, 2001

1,233

US

While Paste Special->Text work?

 

Upvote 0 Downvote

• Feb 15, 2004

• #4

abeltio

Mechanical

May 17, 2002

520

AR

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:
0
00
000
0000 <- your 4/0 which is in reality what it means... 4/0 is short for 0000 (four zeroes)
HTH

saludos.
a.

 

Upvote 0 Downvote

• Feb 15, 2004

• Thread starter
• #5

BJC

Electrical

Jan 29, 2001

2,119

US

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.
BJC

 

Upvote 0 Downvote

• Feb 16, 2004

• #6

cowski

Mechanical

Apr 23, 2000

8,227

US

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.

 

Upvote 0 Downvote

• Mar 8, 2004

• #7

HNGRR

Mechanical

Nov 1, 2002

12

CL

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!

 

Upvote 0 Downvote

• Mar 27, 2004

• Thread starter
• #8

BJC

Electrical

Jan 29, 2001

2,119

US

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.

=IF(K2=36617,"4/0",IF(K2=36586,"3/0",IF(K2=36557,"2/0",IF(K2=36526,"1/0",K2))))

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.

 

Upvote 0 Downvote