On Wednesday March 28 2007 8:33 am, Kirill S. Palagin wrote: > Hello everybody. > > I am trying to change cell format from text to number (Standard) > and Calc adds leading ' to the cell contents. > How do make Calc not do this? > For example please see file http://www.mytempdir.com/1273493 > On first sheet r-click, cell I11, Format Cells, Numbers tab, change > from Text to Number (Standrd), OK -> Calc adds leading apostrophe. > Is there a way to avoid adding ' so that cell can be used in > calculations? > > Thanks a lot. > WBR, > K. Palagin.
Search for .* and replace with &. In the dialogue, press "More Options", select "Regular Expressions" and "Search in Values". (I saved this method because it works with the Linux OOo versions I use. It seems to work for windows versions also, but there is a slightly simpler way also. I did not save what will also work with windows.) Dan --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
