When I open a .csv file with Excel 2002, SP3, I see:
=quot;2005-10-20quot;
in the fomula bar when I am on cell B2. A different user of the same file,
running the same version of Excel sees:
2005-10-20
in the formula bar of cell B2.
Why the difference ?
Thanks !!
Before I'd guess, I'd like to know what's actually in the .CSV file.
If you open the .csv file in NotePad, what do you see?
Eric @ CMN, Evansville wrote:
gt;
gt; When I open a .csv file with Excel 2002, SP3, I see:
gt;
gt; =quot;2005-10-20quot;
gt;
gt; in the fomula bar when I am on cell B2. A different user of the same file,
gt; running the same version of Excel sees:
gt;
gt; 2005-10-20
gt;
gt; in the formula bar of cell B2.
gt;
gt; Why the difference ?
gt;
gt; Thanks !!
--
Dave Peterson
When I opened the file with notepad, I saw:
=quot;2005-10-20quot;
which makes me wonder if the other person I talked to misunderstood me, and
didn't look at the file the same way I did. I'll have to talk with them some
more. Since the csv file is a system generated one, I may be able to get our
MIS group to modify the file, or create a separate one just for my use.
Thanks.
quot;Dave Petersonquot; wrote:
gt; Before I'd guess, I'd like to know what's actually in the .CSV file.
gt;
gt; If you open the .csv file in NotePad, what do you see?
gt;
gt; Eric @ CMN, Evansville wrote:
gt; gt;
gt; gt; When I open a .csv file with Excel 2002, SP3, I see:
gt; gt;
gt; gt; =quot;2005-10-20quot;
gt; gt;
gt; gt; in the fomula bar when I am on cell B2. A different user of the same file,
gt; gt; running the same version of Excel sees:
gt; gt;
gt; gt; 2005-10-20
gt; gt;
gt; gt; in the formula bar of cell B2.
gt; gt;
gt; gt; Why the difference ?
gt; gt;
gt; gt; Thanks !!
gt;
gt; --
gt;
gt; Dave Peterson
gt;
- Nov 21 Wed 2007 20:40
Confusion.....
close
全站熱搜
留言列表
發表留言