Need to open eer file without converting 8-7440 to a date?

P

pnkflydthewall

Trying to pull a report from one program that has file in eer format. Need
to open in excel but Excel auto converts a number (8-7440) into a date in
August. Have tried many different ways to open the report but it converts to
a date everytime. When I format the cells to be 'general' or 'number' it
does not convert the number back correctly (lists 2023658 instead of 8-7440).
Any suggestions? Help...please help....this is driving me to drink.
 
G

Gord Dibben

Try pre-formatting the cells as text before importing.

Or can you export the eer file to to a *.txt file first then open the *.txt
file in Excel?

In the Text Import Wizard you can designate cell formats.

Can you use Data>Import External Data?

You should be able to designate how to treat fields.

i.e. if it looks like a date, treat as Text


Gord Dibben MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

how do i stop excel from converting numbers entered into a date 2
converting 8-digit number to date 6
Time and Date Format 8
how can I save an excel file with long number columns in cvs form. 3
Excel File Converting to a .pdf 1
Columns formatted As Dates Are Exported as a Number to Text 1
How do I convert a fraction to its true decimal, not a date no. 2
Disable auto-formatting dates.... GRRR! 2

Top