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

You'll need a new app to open this about link 1
how do i stop excel from converting numbers entered into a date 2
Excel date question 0
Converting date into text format 1
converting date to text 2
Need Help with a VBA subroutine 0
Excel File Converting to a .pdf 0
Need Help copying part of an Excel Cell? 2

Top