Hi Everyone,

I am using an excel spreadsheet as a linked table in an access database for
an update query. I had it working very nicely for a period of time. I am
not sure if some Microsoft update caused a problem or what. The field I use
t o update my database didn't work until I used this formula to make a new
row.

I have a column of numbers which was retrieved from a data miner program
it's called Acct. For some reason Access doesn't like the formatting so I
insert a blank column to the right and call that PtNum. In the first cell
of this column which is C2, I type this formula =TEXT(B2,"0"). On the
spreadsheets that worked in the past, I see this formula in the fx section
but in my C2 cell I see the same number as what is in my B column. My
problem is now that instead of the number, the forumula is in cell C2 and
not the number it's supposed to pull from B2.

My current version of Excel is 2003(11.8146.8132)sp2

Thanks,
Linda

Either you are in Formula View or C2 was pre-formatted as text.

CTRL + `(backquote above Tab key) to toggle formula view on/off.

If not in formula view, select C2, format to General then F2 key then ENTER
key.


Gord Dibben MS Excel MVP

On Fri, 14 Dec 2007 09:25:41 -0500, "Linda RQ"
wrote:

Hi Everyone,

I am using an excel spreadsheet as a linked table in an access database for
an update query. I had it working very nicely for a period of time. I am
not sure if some Microsoft update caused a problem or what. The field I use
t o update my database didn't work until I used this formula to make a new
row.

I have a column of numbers which was retrieved from a data miner program
it's called Acct. For some reason Access doesn't like the formatting so I
insert a blank column to the right and call that PtNum. In the first cell
of this column which is C2, I type this formula =TEXT(B2,"0"). On the
spreadsheets that worked in the past, I see this formula in the fx section
but in my C2 cell I see the same number as what is in my B column. My
problem is now that instead of the number, the forumula is in cell C2 and
not the number it's supposed to pull from B2.

My current version of Excel is 2003(11.8146.8132)sp2

Thanks,
Linda

It's working...strange, first neither worked, then I also found the formula
checkbox in the tools/options. That didn't work but I closed and saved and
reopened and now it's working...Now I will go back and try my query. If
that works, after I get the 4 months of data updated, I will get a christmas
break after all!

Thanks so much!
Linda

"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
Either you are in Formula View or C2 was pre-formatted as text.

CTRL + `(backquote above Tab key) to toggle formula view on/off.

If not in formula view, select C2, format to General then F2 key then
ENTER
key.


Gord Dibben MS Excel MVP

On Fri, 14 Dec 2007 09:25:41 -0500, "Linda RQ"
wrote:

Hi Everyone,

I am using an excel spreadsheet as a linked table in an access database
for
an update query. I had it working very nicely for a period of time. I am
not sure if some Microsoft update caused a problem or what. The field I
use
t o update my database didn't work until I used this formula to make a new
row.

I have a column of numbers which was retrieved from a data miner program
it's called Acct. For some reason Access doesn't like the formatting so I
insert a blank column to the right and call that PtNum. In the first cell
of this column which is C2, I type this formula =TEXT(B2,"0"). On the
spreadsheets that worked in the past, I see this formula in the fx section
but in my C2 cell I see the same number as what is in my B column. My
problem is now that instead of the number, the forumula is in cell C2 and
not the number it's supposed to pull from B2.

My current version of Excel is 2003(11.8146.8132)sp2

Thanks,
Linda