I often use Excel to crunch data regarding my network devices. Of cource
when I paste large amounts of data into a spreedsheet it tries to figure out
what format my MAC addresses are. Most are ok because it finds numbers and
letters and therefor assumes it's TEXT, howvere there are those few that are
only numbers. It assumes that they are large numbers, trims my leading zeros
and converts to scientifict notation. I then have to walk through the whole
length of the pasted data and fix these values before I can start my data
crunching.

If Excel was able to detect that these were MAC addresses, it would save a
lot of time and potential miscalculations.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...lic.excel.misc