We have a Database program here (SQL not Access) that
exports reports to Excel. These reports contain odd
combinations of numbers that mean something to the users
of the database and to the programmers of it, but not to
me. Anyway, I recently upgraded from Office 2000 on our
terminal server (Win2K) to Office XP. Since then the
num,bers in this worksheet are being truncated and the
formats are changing. For instance, a number such as
2E152 appears as 2.00E+152 or something like 0100a will
appear as 1:00 AM, we are also having the leading 0's for
a number deleted. I know how I can change the format for
each cell individually, but how can I change the
formatting for cells in the entire spreadhseet to read the
munbers as text only. Or some other fix would be great.
I have Office XP on a nother server and this export isn't
goofed like this. Don't understand it and have too much
to do to spend more time on it so any help would be
awesome! Thanks!