The space makes it text, so if I multiply it by a number the result is
#VALUE!


On Thu, 28 Jul 2005 19:02:56 +0200, "Ron de Bruin"
wrote:

Use this
=A1*1

Add-in solution :
DateRefiner have a option to insert a column with formulas for you
http://www.rondebruin.nl/datarefiner.htm



x-- 100 Proof News - http://www.100ProofNews.com
x-- 30+ Days Binary Retention with High Completion
x-- Access to over 1.9 Terabytes per Day - $8.95/Month
x-- UNLIMITED DOWNLOAD