down loading text files

[Frank Kabel]

Hi
sounds like some of your numbers are stored as text. Maybe these cells
include invisible characters. You may try the following macro:
http://www.mvps.org/dmcritchie/excel/join.htm#trimall

 

[CLR]

You may be talking about a column of numbers, which are normally
right-aligned, with some of them having been entered as TEXT and therefore
become left-aligned...........if so, most import procedures allow the user
to set the formatting for each column..........

Vaya con Dios,
Chuck, CABGx3

 

[David McRitchie]

Hi Kumar,
Try the TrimALL macro on my site mentioned by Frank before using
test to columns. Also note in Text to Columns there is an option
about duplicate separators treated as one. You might want them
to be treated as one. Of course the TRIMALL macro may eliminate
extra internal spaces depending on which TRIM you use.
http://www.mvps.org/dmcritchie/excel/join.htm#trimall

Please fix the time on your computer's clock. You can download
a utility to help you correct the time on your computer.
http://www.boulder.nist.gov/timefreq/service/its.htm
ftp://time.nist.gov/pub/daytime/nistime-32bit.exe <-- actual file to download
You must set your system to the correct region (time zone)
Control Panel, Date/Time, Time zone (tab), correct drop down at top.

More information on date and time
http://www.mvps.org/dmcritchie/excel/datetime.htm

 

[kumar]

when down loading table like files somtimes some numbers in a colimn get
pushed right or left??
How to prevent this pls advise

 

[kumar]

my problem is most of the tome it jums to a new column when using text to
colums pharsing either delimited or fixed length
Pls help