| Forum Home | ||||
| Press F1 | ||||
| Thread ID: 36971 | 2003-08-25 04:15:00 | Excel/Word address Label problem | Pepper2 (4123) | Press F1 |
| Post ID | Timestamp | Content | User | ||
| 170313 | 2003-08-25 04:15:00 | I have a database on Excel from which I print address labels using Word 2002. Every thing works correctly except the "Street Number" where the number is a combination of number and alphabetical character. For instance street number 22 prints OK - but 22b prints as a Zero. The relevant column in Excel is formatted as "General" . Any suggestions would be welcomed. Thank you. |
Pepper2 (4123) | ||
| 170314 | 2003-08-25 04:20:00 | have you tried 22-b or 22/b or 22 b | ilikelinux (1418) | ||
| 170315 | 2003-08-25 05:10:00 | Put a ' at the beginning of the address. Instead of 22b, enter it as '22b (the ' character is to the left of the Enter key) That forces Excel to treat it as alpha characters, and the ' symbol should not print or display in the field |
godfather (25) | ||
| 170316 | 2003-08-30 09:26:00 | Thank you folks The column is formatted as general but there is no character prefix to the combined number/charater street numbers to make the software treat it as text. I will now go through the database and make the corrections before using the programme again. |
Pepper2 (4123) | ||
| 1 | |||||