Hi Terry,

Am Mon, 28 Sep 2015 13:17:24 +0100 schrieb Terry Pinnell:

I don't understand why it wouldn't work after formatting as Numbers?
Perhaps it's an Excel 2000 bug, or is it also true in more recent
versions?

sometimes Excel (in all versions) refuses to format text values to
numbers. Then you can force it with Text to columns


Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional