<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2800.1226" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT face=Arial size=2>I am using Windows XP Professional with filePro
5.0.5 and EXCEL 2003.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>I have received an EXCEL file that I need to import
to a filePro file. All of the fields in the filePro file have been defined
as '*'.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>When I save the EXCEL file as a .csv file so I can
import it problems developed with what the EXCEL file lists as phone and FAX
numbers. In the .csv file many of what should be phone numbers turn to
exponential form. This only happens with phone numbers that are entered as
just a string of numbers like 1234567890. When the entry is listed as
123-456-7890 there is no problem.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>When the entry of 1234567890 is hi-lited an
exclamation mark appears and says 'the number in this cell is formatted as text
or has an apostrophe at the beginning'. The entry does have an apostrophe
at the beginning.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Even if I change the format to a number left
justified (or text) and save it, when I re-open the file it is back to the
exponential form.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>What am I doing or not doing to make these entries
correct and stay that way when saved an opened as .csv file. Formatting as
special/phone number does not do anything either.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>When I open the file (saved a .csv) it does
say EXCEL recognizes the file as a sylk file but cannot open it that way and so
will open in another format if I want it to. I say okay.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Thanks in advance.</FONT></DIV>
<DIV><FONT face=Arial size=2>Art Moore</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV></BODY></HTML>