On Sat, Jan 22, 2011 at 7:06 PM, Jean Hollis Weber <jeanwe...@gmail.com> wrote: > And what do I pick in the "Search in" list: Formulas, Values, or Notes? > > > -------------previous note -------------- > 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? >
I left "Search in" set to Formulas. It worked for me. You obviously need to select "Regular expressions". If it's still not working I have no idea why. Does "Find" match the cells with contents? Gareth -- Black Sphere Technologies Ltd. Web: www.blacksphere.co.nz Mobile: +64 27 777 2182 Tel: +64 9 478 8885 Skype: gareth.mcmullin LinkedIn: http://nz.linkedin.com/in/gsmcmullin --------------------------------------------------------------------- To unsubscribe, e-mail: dev-unsubscr...@documentation.openoffice.org For additional commands, e-mail: dev-h...@documentation.openoffice.org
