If you are copying from a website (which I assume you are based on the
statement of you saying online visa statement), then you will need to
convert any spaces with the ASCII Code of "160" to the ASCII Code of "32" or
to convert as empty string, which ever is better suited to your situation.

Why do web sites use ASCII Code 160 instead of the standard ASCII Code of 32
that other software applications (I.e. Excel, Word, Access, Lotus Notes,
etc...) use?

Main reason, ASCII code 160 has a fixed length spacing for HTML coding while
ASCII code of 32 is not a fixed length. By using fixed length spaces, they
can have tables shown with the proper borders and what not. Imagine
attempting to doing ASCII art with true type fonts (New Courier) as opposed
to the old traditional fixed width character fonts (Courier). This is the
basic reason why web sites use ASCII code of 160 for spaces while other
applications use ASCII code of 32.

As for Excel formulas when attempting to use the ones that suppose to
convert text to numbers, they are not programmed to pick up the ASCII code
of 160 like they do with the ASCII code of 32.

--
Thanks,

Ronald R. Dodge, Jr.
Production Statistician
Master MOUS 2000
"Aussie Rob" wrote in message
...
It appears that the copy and paste method of transfer from my online visa
statement was causing the problem. If I enter the value manually then the
formula will work. If I copy and paste then it will not work.

"Aussie Rob" wrote:

1 Shut down the computer and started again. No change to the problem.

Opened the file direct from "my documents menu" so no other file open.


Auto Calculation is on

Column goes all the way to Row 2 - Row 1 is the column Header
"Restaurant"


"Ronald R. Dodge, Jr." wrote:

A few possible things could be happening.

If you have it in manual calculation mode, it obviously won't calculate
which could be caused by opening up a workbook that has manual
calculation
set in it (if there is no other workbook already open when that one
workbook
is opened)

If you purposely have it in manual calculation and press the F9 key, it
works for more simple calculations, but as calculations gets to be more
complex, it no longer works properly, so that's why I refuse to use the
F9
function by itself within Excel. You can use Shift F9 to calculate
just the
worksheet or Alt-Ctrl-F9 to force an entire calculation across all open
workbooks.


If you are putting in formulas and nothing is calculating properly,
even
after pressing Alt-Ctrl-F9, then chances are, something may not be
working
properly and generally when this happens, have to reboot the system.

The column where you putting the formula in may not be going all the
way up
the column (if there are breaks in the column in between records), so
be
careful with this aspect, especially if using something like subtotals.
When you first click on the cell, you can press Alt-= (That is to press
and
hold the Alt key as you press the = [Equal] key), then within the range
highlighted, you may select the range or directly edit the range, which
will
take you from Point mode to Edit mode of editing the formula in the
cell.


--
Thanks,

Ronald R. Dodge, Jr.
Production Statistician
Master MOUS 2000
"Aussie Rob" wrote in message
...
I am working on a financial spreadsheet and use the "IF" formula to
place
information in a result column. =IF(F2="restaurant",C2,0)
This formula puts the value into the restaurant column but when I ask
for
"autosum" for the resultant column it will not calculate. Any
suggestions?