data in some cells of worksheet appear as #### why?
 

When I saved the data originally it was fine then when i came back to work on
it in the morning it appeared as a row of ##### can anyone tell why & how I
can get my data to appear corectly?

Because the column is not wide enough. Widen it.

--
HTH

Bob Phillips

"jlacmana" wrote in message
...
When I saved the data originally it was fine then when i came back to work
on
it in the morning it appeared as a row of ##### can anyone tell why & how
I
can get my data to appear corectly?

Are you running xl97?

Some posters say that upgrading to SR2 helps. But others have said that it had
no effect.

If you're not running xl97SR2, you may want to try it.

jlacmana wrote:

When I saved the data originally it was fine then when i came back to work on
it in the morning it appeared as a row of ##### can anyone tell why & how I
can get my data to appear corectly?

--

Dave Peterson

data in some cells of worksheet appear as #### why?
 

Woah.. It really was that simple!! I was tearing my hair out over it!
The Excel help in the program is really useless. Thanks so much Bob!

-m.m.m.

"Bob Phillips" wrote:

Because the column is not wide enough. Widen it.

--
HTH

Bob Phillips

"jlacmana" wrote in message
...
When I saved the data originally it was fine then when i came back to work
on
it in the morning it appeared as a row of ##### can anyone tell why & how
I
can get my data to appear corectly?

data in some cells of worksheet appear as #### why?
 

If you look under help for "error" you will find "how to correct ##### error"

So not really that useless, is it?


Gord Dibben MS Excel MVP

On Mon, 14 Jul 2008 09:28:01 -0700, m.m.m.
wrote:

Woah.. It really was that simple!! I was tearing my hair out over it!
The Excel help in the program is really useless. Thanks so much Bob!