View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.newusers
gls858
 
Posts: n/a
Default having ####### shown in excel

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