Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
text being returned as #######
Text is being returned as ######## in a cell; however, when you click on the
cell it will actually display the text in a readable format. Please advise. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
text being returned as #######
Most likely your column just isn't wide enough for the text in the format you've chosen. Expanding the column widht should do the trick. "ACICS_Admin" wrote: Text is being returned as ######## in a cell; however, when you click on the cell it will actually display the text in a readable format. Please advise. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
text being returned as #######
expand yr column/row
On 19 Gru, 15:54, ACICS_Admin wrote: Text is being returned as ######## in a cell; however, when you click on the cell it will actually display the text in a readable format. *Please advise. * |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
text being returned as #######
Format the cell as General.
String lengths between 256 and 1024 in cells formatted as Text cause this problem. ACICS_Admin wrote: Text is being returned as ######## in a cell; however, when you click on the cell it will actually display the text in a readable format. Please advise. -- Dave Peterson |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
text being returned as #######
I expanded the row and also have the 'wrap text' alignment on. Some cells
with text are just fine, while others are returnning the ######. Can you think of anything else? Thanks! "Jarek Kujawa" wrote: expand yr column/row On 19 Gru, 15:54, ACICS_Admin wrote: Text is being returned as ######## in a cell; however, when you click on the cell it will actually display the text in a readable format. Please advise. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
same name being returned | Excel Discussion (Misc queries) | |||
Using COS in VBA, incorrect value returned | Excel Worksheet Functions | |||
#N/A value is returned | Excel Worksheet Functions | |||
How do I convert cells containing formulas to text (value returned | Excel Worksheet Functions | |||
#Value! Returned ? | Excel Worksheet Functions |