| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excess text reverts to ######## , any way around this?
|
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excess text reverts to ######## , any way around this?
Format the cell as General.
niamh wrote: -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excess text reverts to ######## , any way around this?
The reformat to general works within the spreadsheet, but if it is necessary
to export to a csv file using the text format, the ### shows up in the file when opened in WORD. Does anyone know how to actually fix the problem? Or what causes it? "Dave Peterson" wrote: Format the cell as General. niamh wrote: -- Dave Peterson |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excess text reverts to ######## , any way around this?
Before I'd venture a guess, I'd want to know how long the string is and how you
created the .csv file. And if you open that .csv file using NotePad, do you still see the same problem? And the version of excel/word that you're using. cd wrote: The reformat to general works within the spreadsheet, but if it is necessary to export to a csv file using the text format, the ### shows up in the file when opened in WORD. Does anyone know how to actually fix the problem? Or what causes it? "Dave Peterson" wrote: Format the cell as General. niamh wrote: -- Dave Peterson -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Shade cell according to text? | Excel Discussion (Misc queries) | |||
| Using Concatenate function to generate text in Text Box | Charts and Charting in Excel | |||
| merged cells into one text cell, size varies dependant on text dat | Excel Discussion (Misc queries) | |||
| SUMPRODUCT vs Text??? | Excel Worksheet Functions | |||
| Read Text File into Excel Using VBA | Excel Discussion (Misc queries) | |||
Linear Mode
