| View previous topic :: View next topic |
| Author |
Message |
Obolensky
General User
Joined: 09 Mar 2011
Posts: 6
|
 Posted: Wed Mar 09, 2011 1:35 pm Post subject: Find&Replace with numbers |
 |
|
Hi everyone
I have a spreadsheet with a column of numbers, but instead of using the digit 0 the source has put N. I need the data to have 0 and I tried using Replace All but it doesn't change anything. I tried it in a different column to change 1, 2 etc into 1st, 2nd etc.
Any ideas? |
|
| Back to top |
|
 |
Villeroy
Super User
Joined: 04 Oct 2004
Posts: 10065
Location: Germany
|
| Posted: Wed Mar 09, 2011 1:43 pm Post subject: |
|
|
menu:Find&Replace
Search: N
Replace: 0
[X] Entire Cells
[Replace All]
Of course this works.
_________________
Rest in peace, oooforum.org
Get help on http://forum.openoffice.org |
|
| Back to top |
|
|
Obolensky
General User
Joined: 09 Mar 2011
Posts: 6
|
| Posted: Wed Mar 09, 2011 2:58 pm Post subject: |
|
|
| Villeroy wrote: | menu:Find&Replace
Search: N
Replace: 0
[X] Entire Cells
[Replace All]
Of course this works. |
Nope, worked in Excel on my housemates computer once I realised there was a space after the N but when I tried putting the space in on OpenOffice it didn't. |
|
| Back to top |
|
|
|
