Excel 2000 LARGE text fields display number-signs

July 24, 2012 at 07:02:57
Specs: Windows Vista
In Excel 2000, Cells formatted as text with lots of content 1) do not wrap, 2) do not truncate. They just display as #######. Column width adjustment is impossible as text exceeds 255. Smaller text fields that surpass screen width will truncate. I need a way to fix this. Upgrade to Excel 2010 is not possible because Microsoft has eff'd up all the under coding and functions I need.

See More: Excel 2000 LARGE text fields display number-signs

Report •


#1
July 26, 2012 at 14:25:38
Double-clicking on the column divider line should set the column width to show the entire contents of the cell. Does that not work for you?

Report •

#2
July 27, 2012 at 07:12:50
That does not work for large fields. Excel 200 will expand to a column width of 236.71, while the field is 255. This is imported data from an external database.

Report •

#3
July 27, 2012 at 08:04:07
Have you tried inserting your 255+ line in a Text Box,
don't know what the limit is for Text Box's.

Microsoft has eff'd up all the under coding and functions I need.

Would be curious to know the changes you speak of.

MIKE

http://www.skeptic.com/


Report •

Related Solutions

#4
July 30, 2012 at 05:09:05
My major issues is hiding all of the most important commands like Format Cells, Move/Copy Worksheet, Recording Macros.. Excel is not half as bad as Access 2010 which is unusable, none of my code will run. So I have to keep Office 2000 around to get my work done. It takes a long time in Office 2000 and an Internet search to find basic commands since the Help files have proved totally useless.

Report •

#5
July 30, 2012 at 13:19:25
My major issues is hiding all of the most important commands like Format Cells, Move/Copy Worksheet, Recording Macros.

I went from 2000 to 2007 and there is a learning curve,
but I did not find it that difficult.
It seems daunting at first, but, as with most things, you adjust.

I can't comment on your Macros, but all of my worksheets worked the first time,
after the upgrade.

It takes a long time in Office 2000 and an Internet search to find basic commands

Here's a file I keep around, you might find handy:

http://www.xlfdic.com/

I've been using it since version 2.

MIKE

http://www.skeptic.com/


Report •

Ask Question