Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default Need to open eer file without converting 8-7440 to a date?

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.
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 22,906
Default Need to open eer file without converting 8-7440 to a date?

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 DataImport 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

On Mon, 10 May 2010 15:05:01 -0700, pnkflydthewall
wrote:

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.


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Open file if cell date is less than today+30 day? NeedToKnow Excel Worksheet Functions 2 August 19th 09 07:29 PM
Date open file with date saved Rita Excel Worksheet Functions 3 April 23rd 09 03:13 PM
Incorrect date value when open DBF file in Excel officelady Excel Discussion (Misc queries) 0 September 3rd 08 05:34 AM
todays's function, if I open file date changes MaT Excel Discussion (Misc queries) 1 November 22nd 07 08:45 PM
Excel File Open Box - want Date Modified Titian Excel Discussion (Misc queries) 2 February 26th 06 09:25 AM


All times are GMT +1. The time now is 11:31 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"