Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Why does my formula bar display a lengthy string, but my cells display #####?
Hello--I have a somewhat complex macro that fills a number of cells
with numbers and words that are formatted as text ("@"). For some reason, it fills certain cells with ##### even as the menu bar displays their proper contents. Does anyone have an idea of where I might start looking to solve thie problem? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Why does my formula bar display a lengthy string, but my cells display #####?
try making the column width bigger?
wrote in message oups.com... Hello--I have a somewhat complex macro that fills a number of cells with numbers and words that are formatted as text ("@"). For some reason, it fills certain cells with ##### even as the menu bar displays their proper contents. Does anyone have an idea of where I might start looking to solve thie problem? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Why does my formula bar display a lengthy string, but my cellsdisplay #####?
If the amount of text is between 255 and 1024 characters and the cell is
formatted as text, then you'll see ####'s. Try changing the format to General. If you need to force text (say you have 300 digits to put in the cell), just prefix the entry with an apostrophe: dim myVal as string myval = "123412341234123412.....etc for 300 digits!" activecell.value = "'" & myval wrote: Hello--I have a somewhat complex macro that fills a number of cells with numbers and words that are formatted as text ("@"). For some reason, it fills certain cells with ##### even as the menu bar displays their proper contents. Does anyone have an idea of where I might start looking to solve thie problem? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cells display as R5C5. How do I change it to display E5? | Excel Discussion (Misc queries) | |||
How to display the values of multiple cells in a text string? | Excel Worksheet Functions | |||
some cells display formulas, some display values | Excel Discussion (Misc queries) | |||
Cells only display formula | Excel Worksheet Functions | |||
Formula cells needs to display "zero" | Excel Discussion (Misc queries) |