If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
having ####### shown in excel
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?!?! |
#2
|
|||
|
|||
having ####### shown in excel
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?!?! |
#3
|
|||
|
|||
having ####### shown in excel
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?!?! |
#4
|
|||
|
|||
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 |
#5
|
|||
|
|||
having ####### shown in excel
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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Dynamic Excel chart in PowerPoint... | Rob | Powerpoint | 5 | November 5th, 2005 03:32 AM |
Display form from an VB application in Excel | kuhni | General Discussion | 0 | August 10th, 2005 06:04 PM |
Add-in functions when starting Excel programmatically | Steve K. | Worksheet Functions | 11 | July 2nd, 2004 06:38 PM |
Coverting Lotus 123 files to use with excel | Muffin1947 | General Discussion | 6 | June 20th, 2004 10:18 AM |
Ctrl+A macro fix for problem in Excel 2003 | David McRitchie | General Discussion | 4 | June 19th, 2004 12:01 PM |