In microsoft.public.money, Martin wrote:

- quote -

I confirm this when I test it in Money 2005.

Whether the bank should be entering an amount without an explicit
decimal point, I don't know. But I confirm that a T100 line in a QIF
will come in as $100.00 in the not-automatically insert mode, and
$1.00 in the other setting.

Nice find. Is the bank at fault, Money at fault, or both? I guess
that would depend on tracking down a QIF standard.
http://www.respmech.com/mym2qifw/qif_new.htm is one, but not
definitive or explicit. Example QIF files that I remember always
have an explicit decimal. So if that were the case in your download
file, the problem would not have arisen. And while Quicken would
seem to be the authority on Quicken Interchange Format, they are
trying to kill QIF opting for more proprietary methods.

There is anther case where a setting more commonly affects QIF file
interpretation. Banks differ on using MM/DD vs DD/MM. Money uses the
Windows settings to make that call.

Check the decimal settings in Windows' Regional Settings.
-Mark

"Martin" <Martin[at]discussions.microsoft.com> wrote in message
news:B612BED7-FFA8-46B0-8EDC-CBA1E2820FC4[at]microsoft.com...
- quote -

Correction to my previous post-
The values that Excel & Word produced was 1
Not .01 as I had indicated.
Martin

"Martin" wrote:

- quote -

Cal,
Under tools-options-editing, the add decimal point automatically was
selected by default.

When I had opened the file in Quattro it showed correct values ie: 1.00.

When I opened the file in both Word & Excel, the values changed when
displayed ie: .01.
I re-imported same file without decimal point auto entry and values were
correct.
Martin

"Cal Learner-- MVP" wrote:

- quote -

In microsoft.public.money, Martin wrote:

- quote -

Are you sure that is the same QIF file that you previously loaded
and got the wrong values?

That's odd. Don't overwrite your recent backups.

I suggest you reboot your computer. Then try
File-> RepairMoneyFile-> QuickFileRepair in Money. It seems unlikely
to help, but it won't hurt.

If the problem remains, try creating a new empty Money file, named
something like Test.mny. Then File-> Import that QIF file to see what
happens.





- quote -

Cal,
Thanks for the response.
I did look at the QIF file after understanding what it was and how to open
the file.
The QIF file showed the decimal point in correct position.
Martin

"Cal Learner-- MVP" wrote:

- quote -

In microsoft.public.money, Martin wrote:

- quote -

Look at the QIF file to find out.

I'm using Money 2004 Deluxe.
This past week when I imported a QIF file into Money from my financial
institution and the decimal point shifted 2 spaces to left in all but 2
entries. Instead of 400.00, the result was 4.00.
Has this occurred to anyone?
Iv'e been using the software for the past 3 months and this is the first
time it had occured.
Money or Financial institution problem??