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?

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?

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