Unwanted number format conversion
Hi gang,
I've mostly worked out what is going on, here.
In my example, the cells in question contain values like "0390", which are
codes for our company's branches. These come into the spreadsheet (along
with other data) via an MS Query from a database on a server. The branch
code field in the source table is a string of length 4.
So, a branch code goes into a worksheet cell, via MS Query, with the leading
"0" intact. But, because the destinatioin cell has the default format
'General', editing the cell causes it to be reinterpreted as a 'Number', and
the zero gets chopped.
I guess I now have less reason to be peeved about this behaviour, but it
would be nice if Excel would try to preserve or mimic the data types of
fields in external data sources. Is there, in fact, a way to make this
happen?
Thanks for bearing with me!
|