Automatic formatting when pasting or importing data

[Corey]

How can I get Excel 2003 to stop trying to figure out how
to display data which is pasted or imported from a text
file? For example, if I paste several columns of tab-
seprated numbers into a worksheet, sometimes Excel
formats these as currency with the dollar sign ($) and
two decimal places. I'd like Excel to display the
numbers as they in the source, with or without decimal
places.

 

[nilizandr]

I'm not sure about Excel 2003, but in Excel XP, you can paste as value
(as recommended below) or paste with formatting of current document, o
paste with formatting of original.
In Excel XP, after you paste, one of those "smart tips" icons appears
and you can choose pasting options after the fact.

With regard to the CSV file, select that A column with the value
separated by commas, and then go to the data pulldown menu, and selec
"text to columns" indicated that you have text delimited by commas, an
voila! your problem is solved

 

[nilizandr]

I'm not sure about Excel 2003, but in Excel XP, you can paste as value
(as recommended below) or paste with formatting of current document, o
paste with formatting of original.
In Excel XP, after you paste, one of those "smart tips" icons appears
and you can choose pasting options after the fact.

With regard to the CSV file, select that A column with the value
separated by commas, and then go to the data pulldown menu, and selec
"text to columns" and indicate that your text is delimited by commas
and voila! your problem is solved!
P.S. Text to columns is awesome, because you can spearate text that'
delimited by any character(s) at all or just chop data into fixed-widt
columns