On Sat, 2011-01-22 at 19:28 +1300, Gareth McMullin wrote: > On Sat, Jan 22, 2011 at 7:06 PM, Jean Hollis Weber <jeanwe...@gmail.com> > wrote: > > > > Doesn't work for me. Here are all the steps I did: > > > > Format the cells as number, select the Regular expressions option, > > select the cells A1, A2, A3, type .+ in the Search for box, & in the > > Replace box, and click Replace. > > > > No change to any cell. > > > > What am I missing? > >
> Does "Find" match the cells with contents? I'm not sure I understand the question. Find didn't appear to do anything when the info in the cells was '1, '2, etc. After running F&R, the cells still contained '1, '2, etc. And the sum was still zero. --Jean --------------------------------------------------------------------- To unsubscribe, e-mail: dev-unsubscr...@documentation.openoffice.org For additional commands, e-mail: dev-h...@documentation.openoffice.org