View Single Post
 
Old 05-03-2011, 05:54 AM
OTPM OTPM is offline Windows 7 32bit Office 2010 32bit
Expert
 
Join Date: Apr 2011
Location: West Midlands
Posts: 981
OTPM is on a distinguished road
Default

Hi
Two things you could try:
1. for those "numeric values" you do not want Excel to treat as numbers you need to put a single quote in front of the entry. This forces excel to treat the entries as text.
2. Format the relevant column in Excel as text.
The first option should do the trick though.
Hope this helps.
OTPM
Reply With Quote