Hi, Trying to understand. What you are saying is that the " 1", " 2", " 3" are text? And you want to change them to numerical values without the quotes or leading spaces? And you say the "numbers" as text, were "inserted" in the spreadsheet? By whom? How many rows do the "numbers" go?
Getting rid of the spaces - just change the column width. Place the cursor (white arrow) over the column header you want to change so that the cursor (white arrow) becomes a black verticle line with left and right arrows to signify you're in the column width change mode, and change to whatever column width you want - narrower to get rid of the spaces before the numbers. The following is from the HELP in Calc. "If you want to apply a numerical format to a column of numbers in text format (for example, text "000123" becomes number "123"), do the following: 1.Select the column in which the digits are found in text format. Set the cell format in that column as "Number". 2.Choose Edit - Find & Replace 3.In the Search for box, enter ^[0-9] 4.In the Replace with box, enter & 5.Check Regular expressions 6.Check Current selection only 7.Click Replace All " Greg --- Thomas J Moore <[EMAIL PROTECTED]> 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] > > ********** "Of all the dispositions and habits which lead to political prosperity, religion and morality are indispensable supports. In vain would that man claim the tribute of patriotism who should labor to subvert these great pillars of human happiness - these firmest props of the duties of men and citizens. The mere politician, equally with the pious man, ought to respect and to cherish them." * * * * George Washington Farewell Address Philadelphia, September 7, 1796 ********* --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
