I have a spreadsheet with 1375 rows. One of the colums is a time
column, with the format 'hh:mm:ss. Note the leading ' sign. In order
to sum this column, I need to remove this character. However, the
search and replace dialogue s not recognize this character. How can I
remove them all easily?
Than
On Thu, Dec 17, 2009 at 7:46 AM, Dotan Cohen wrote:
> I have a spreadsheet with 1375 rows. One of the colums is a time
> column, with the format 'hh:mm:ss. Note the leading ' sign. In order
> to sum this column, I need to remove this character. However, the
> search and replace dialogue s not reco
On Thursday 17 December 2009 18:16:40 Dotan Cohen wrote:
> I have a spreadsheet with 1375 rows. One of the colums is a time
> column, with the format 'hh:mm:ss. Note the leading ' sign. In
> order to sum this column, I need to remove this character.
> However, the search and replace dialogue s no
Dotan Cohen ha scritto:
I have a spreadsheet with 1375 rows. One of the colums is a time
column, with the format 'hh:mm:ss. Note the leading ' sign. In order
to sum this column, I need to remove this character. However, the
search and replace dialogue s not recognize this character. How can I
rem
On 12/17/2009, Marcello Romani (mrom...@ottotecnica.com) wrote:
> Do you see the ' character in the cell or only in the value bar ? I
> ask because I happen to have some spreadsheets in which I read 0,00
> in the cells, but I see '0,00 in the value bar. The leading ' tells
> OOo that the cell is to
Tanstaafl ha scritto:
On 12/17/2009, Marcello Romani (mrom...@ottotecnica.com) wrote:
Do you see the ' character in the cell or only in the value bar ? I
ask because I happen to have some spreadsheets in which I read 0,00
in the cells, but I see '0,00 in the value bar. The leading ' tells
OOo th
At 14:46 17/12/2009 +0200, Dotan Cohen wrote:
I have a spreadsheet with 1375 rows. One of the columns is a time
column, with the format 'hh:mm:ss. Note the leading ' sign. In order
to sum this column, I need to remove this character. However, the
search and replace dialogue [does] not recognize
2009/12/17 Dotan Cohen :
> I have a spreadsheet with 1375 rows. One of the colums is a time
> column, with the format 'hh:mm:ss. Note the leading ' sign. In order
> to sum this column, I need to remove this character. However, the
> search and replace dialogue s not recognize this character. How ca
At 20:30 17/12/2009 +0100, Johnny Rosenberg wrote:
[...] And there's more: Opening my example file
I can see numbers in a lot of cells. When
selecting a cell, the input line shows, for example:
'285
The cell itself displays:
285
BUTÂ… when I manually enter '285 in a cell, that
cell actually d