• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 274
  • Last Modified:

MS Excel 2007 format "###############" error

I have merged several cells and just typing text on these cells.  All of a sudden, the text turned into "####################".  When I click on them, they show the actual text but when I tab out of the text, they show the '############" format.  
Help!!!
0
adalon
Asked:
adalon
  • 5
  • 4
  • 3
  • +2
1 Solution
 
Saurabh Singh TeotiaCommented:
The reason because you need to adjust the column width, If you adjust the column width they will look perfectly..
Saurabh...
0
 
Patrick MatthewsCommented:
Try widening the columns.  When you have a numeric value whose format does not "fit" in the current column
width, Excel will generally display ###############.

Patrick
0
 
Patrick MatthewsCommented:
Too slow :)
0
Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

 
Saurabh Singh TeotiaCommented:
By adjusting i mean you need to increase the column width.
Saurabh...
0
 
adalonAuthor Commented:
I have some sort of a fixed column width.  I have the wrap text on and I use Alt Enter to get it to the next line.  I thought the text will wrap and I will just have to adjust the Row width.  Bottomline, adjusting the column width is not an option.  Please help again!
0
 
TextReportCommented:
Have you tried to incread the row height if you can adjust the column width?

When you say you have Merged Cells, I take it you have used the Merge option on the Home, Alignment ribbon? If so this should not change to #'s as it should spread across all the available cells that you have merged. This is also the case even if you have just merged 1 cell. The wrapping and format should be honoured.

Cheers, Andrew
0
 
adalonAuthor Commented:
Yes, I have adjusted the row  height.  That's what I thought also, but still, the text are being changed to #'s.
0
 
Brian WithunCommented:
I can't seem to reproduce what you're seeing with merged cells.

Could your worksheet or workbook be protected?
Are you entering a great deal of text?
How many cells are merged together?
What is the formatting of the cell?

can you attach your file, or a pared down example of what's happening?


0
 
adalonAuthor Commented:
Worksheet and workbook are not protected.  Attached is the excel file.  Thank you.
Excel-Error.xls
0
 
TextReportCommented:
There is something with your format on the merged cells, just don't know what yet. If your copy the contets of the cell to another sheet and in effect start again it is visible, but if you use the Format Painter it goes back to the #'s
Still looking
Cheers, Andrew
0
 
TextReportCommented:
It looks like it is the Format as Text that is causing it.
Cheers, Andrew
0
 
Saurabh Singh TeotiaCommented:
Do these steps-->right click on the cell-->format cell-->alignment-->uncheck the option of wrap text and then hit ok.
Then again follow the steps and this time check the option of wrap text also before checking that check the option of shrink to fit and hit ok
and now you will see your text in the cell.
0
 
TextReportCommented:
Just Format the Cell as General and the text appears. Right Mouse Menu, Format Cells, Number, Category: General.
Cheers, Andrew
0
 
adalonAuthor Commented:
saurabh726:

I tried your suggestion.  I see the ### wrapped (became 3 lines instead of one).  But it still shows as # sign and I can't still see the text.  

Thanks!
0
 
adalonAuthor Commented:
Thank you all!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 5
  • 4
  • 3
  • +2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now