> -----Original Message----- > From: Dan Lewis [mailto:[EMAIL PROTECTED] > Sent: Wednesday, March 28, 2007 8:48 AM > 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
Thanks very much for the tip! Is Calc's behavior is intended or should I file a bug (see http://www.openoffice.org/servlets/ReadMsg?listName=users&msgNo=49899) ? WBR, K. Palagin. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
