Thread
:
opening csv
View Single Post
#
5
Nick Hodge
Posts: n/a
Jo
See Frank's reply re regional settings
--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
HIS
"Jo Segers" <Jo
wrote in message
...
Thanks Nick,
But why does it open differently on one pc than on the other?
"Nick Hodge" wrote:
Jo
Excel sees any file with the extension *.csv as a native file and tries
to
open it straight away. Once in Excel you could parse it using DataText
to
columns
Alternatively, remove the extension or replace it with .txt and Excel
will
launch the text import wizard
--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
HIS
Reply With Quote