close

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;

arrow
arrow
    全站熱搜
    創作者介紹
    創作者 software 的頭像
    software

    software

    software 發表在 痞客邦 留言(0) 人氣()