hi all, i am a newbie in excel...
encounter this problem...trying to enter a series of numbers
Ie; 132,133,134,135,136,137,138,139,140,141,142,143,14 4,145

onto row 1,2 and 3 under ONE column, i merged it
enter the desired numbers, but result shown '#########'

Anyone can guide me?!?!

It looks as though the column width is too narrow to accommodate the
information in the cell.

Click on the cell (or column or row) and <Format <Column or <Row (as
appropriate) <AutoFit selection

Come back if that doesn't solve the problem.

Regards.

Bill Ridgeway
Computer Solutions

"Richie" wrote in message
...
hi all, i am a newbie in excel...
encounter this problem...trying to enter a series of numbers
Ie; 132,133,134,135,136,137,138,139,140,141,142,143,14 4,145

onto row 1,2 and 3 under ONE column, i merged it
enter the desired numbers, but result shown '#########'

Anyone can guide me?!?!

Hi Bill;

unable to resolve my problem.

what i actually did was i pre-adjusted the column length, merged row 1,2 and
3 on that desired column. keyed in my series of numbers, ##### sign appear.

i actually adjust the column and row size- auto fit, but problem still
unsolved.
sorry to ask if u follow the way i did, does this problem arise to you.

Can i have a more briefed detail to solve this

Thankx, i appreciate it

"Richie" wrote:

hi all, i am a newbie in excel...
encounter this problem...trying to enter a series of numbers
Ie; 132,133,134,135,136,137,138,139,140,141,142,143,14 4,145

onto row 1,2 and 3 under ONE column, i merged it
enter the desired numbers, but result shown '#########'

Anyone can guide me?!?!

Richie wrote:
Hi Bill;

unable to resolve my problem.

what i actually did was i pre-adjusted the column length, merged row 1,2 and
3 on that desired column. keyed in my series of numbers, ##### sign appear.

i actually adjust the column and row size- auto fit, but problem still
unsolved.
sorry to ask if u follow the way i did, does this problem arise to you.

Can i have a more briefed detail to solve this

Thankx, i appreciate it

"Richie" wrote:

hi all, i am a newbie in excel...
encounter this problem...trying to enter a series of numbers
Ie; 132,133,134,135,136,137,138,139,140,141,142,143,14 4,145

onto row 1,2 and 3 under ONE column, i merged it
enter the desired numbers, but result shown '#########'

Anyone can guide me?!?!

Give more detail as to what EXACTLY what you're trying to do.

Is 132 in A1, 133 in A2 and 134 in A3 and so on? What do you mean by
"I merged it and entered the desired numbers"? Are you trying to put
more than one number in the merged cell or are you trying to merge cells
with data already in them. Your post isn't very clear. Remember we can't
see what you see. Give us details.

gls858

Preformat that cell as Text or start your entry with a leading apostrophe:

'123,123,123,123,123,123,123...

Richie wrote:

hi all, i am a newbie in excel...
encounter this problem...trying to enter a series of numbers
Ie; 132,133,134,135,136,137,138,139,140,141,142,143,14 4,145

onto row 1,2 and 3 under ONE column, i merged it
enter the desired numbers, but result shown '#########'

Anyone can guide me?!?!

--

Dave Peterson