Ensuring that number formats are carried over hwen converting from XL to CSV

[DeaconMet]

I am dealing with a file that involves IDentification numbers likes this:

123-45

The client gave us these numbers with the dashes in them so we would like to keep them. Unfortunately, even using formatting as text, when the conversion is done to CSV, the "123-45" changes. How can I eliminate this issue?

[ADoubleDot]

I had a problem like this, very frustrating.

I ended up just appending a character to the beginning like a123-45. This forced it to be read/stored as text. Then I pulled it back off for the final display. A little cumbersome, but once it was setup I never had to think about it again.

I'm sure there is some better solution but quick-and-dirty works.

[DeaconMet]

Originally Posted by ADoubleDot

I had a problem like this, very frustrating.

I ended up just appending a character to the beginning like a123-45. This forced it to be read/stored as text. Then I pulled it back off for the final display. A little cumbersome, but once it was setup I never had to think about it again.

I'm sure there is some better solution but quick-and-dirty works.

Yeah I tried that and it didn't work though. Thanks though.

[Huki]

Originally Posted by DeaconMet

I am dealing with a file that involves IDentification numbers likes this:

123-45

The client gave us these numbers with the dashes in them so we would like to keep them. Unfortunately, even using formatting as text, when the conversion is done to CSV, the "123-45" changes. How can I eliminate this issue?

Paste the file into a single column then parse it with MID.