RE: Exel 2007

Hello Nestor

Thank you for your question.

Have you tried creating a custom number format for the column (or row) the data is being pasted into?

If you select the column/row/cells that the data is going to be pasted into; then go into your Number Formats (where you have been choosing Text as your format); select Custom instead of Text, and in the box under where it says Type: enter nine zeros (000000000) or nine hashes (#########); click OK. Then try pasting your data.

I'm not sure about whether there's any way of stopping Excel pasting in the format it chooses by default, I'll look into this.

Let me know if the custom number format works for you.

Kind regards
Amanda

RE: Exel 2007

Oh dear, I hoped that would help.

A bit long winded, but what if you paste the codes into a text (Notepad) file; then import the file into Excel either by opening the file within Excel; or using the Text to Columns wizard (on the Data tab)?

Kind regards
Amanda

RE: Exel 2007

Hi Nestor

I just tested the following, it seems to work.

1. Copy and paste the codes into Notepad.
2. Copy the codes from Notepad.
3. Paste into Excel.
4. Click the Paste smart tag that appears in the bottom right under the pasted codes.
5. Select Import Text Wizard.
6. At step 1 of the import wizard, check File origin says Windows (ANSI); click Next.
7. Don't change anything at the next screen; click Next.
8. At step 3, select Text under Column Data Format.
9. Click Finish.

The codes should appear as you wish. Click the ! smart tag, select Ignore Error to make the green triangles disappear.

Hope this works for you.

Kind regards
Amanda