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