quote:
but if you put a single quote before the numeric value, Excel will automatically treat it as text
Only because single quote is not a numeric value. The single quote will be part of the text in the cell, eg '0001 will be '0001 (5 chars). This is different to typing in '0001 which will result in 0001 (4 chars) or using F2 on a cell containing '0002 which will result in 0002 (4 chars). It is all due to csv files not having formatting.
Edited by - davidburrows on 12/11/2003 05:59:19 AM
Far away is close at hand in the images of elsewhere.
Anon.