| Home |
| Search |
| Today's Posts |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
I type text into a cell and get pound signs instead
That did it...thank you!!
"Dave Peterson" wrote: Excel has a problem with cells formatted as text where the value is between 255 and 1024 characters long. Formatting as General will fix the display. r1971 wrote: I have free text fields in a spreadsheet I developed so co-workers can provide status updates on their work. Occasionally, when someone types in a status update, the cell only displays pound signs (################). If I select that cell, the text appears in the formula bar, but the active cell just shows pound signs. It doesn't seem to be related to the amount of text that was typed, because other text entries are longer but they display just fine in the cell. How do I fix this? Thank you. -- Dave Peterson . |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Why does my text appear as pound signs | Excel Discussion (Misc queries) | |||
| Excel 07 - text displays as pound signs | New Users to Excel | |||
| pound signs cell formatting | Excel Discussion (Misc queries) | |||
| Pound (#) signs instead of text | Excel Discussion (Misc queries) | |||
| Why is my text changing to pound signs? | Excel Discussion (Misc queries) | |||
Threaded Mode
