insert a new column, and use the formula VALUE(original cell
reference) -- that will give you the number you are looking for. If
you need to delete the original column copy the new one you created,
and then --> paste special and make sure just "number" is checked.
Andy
Spitfire Computer Services
441 Beaver Street
Suite 202
Sewickley, PA 15143
Phone (412) 749-0162
Fax: (412) 749-0203
[EMAIL PROTECTED]
www.spitcomp.com
On Sep 27, 2005, at 10:26 PM, Thomas J Moore wrote:
Hi, I am looking for a way to remove leading spaces from a column
of numbers that was inserted into a spreadsheet. so the column
entries look like (without the quotes) " 1", " 2", " 3",... and I
would like it to be "1", "2", "3",.... so I can sum the column
without having to manually remove the leading space from each of
the numbers in the column... Is there an easy way to do this??
any help would be greatly appreciated
Thanks
Tom Moore
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
