I have created .xls file from a database of another program.
But excel does not treat the data the way I want. Example:

in one cell there is a value 126:00

126 should stand for hours, 00 should stand for minutes

If I want to sum two cells I get #VALUE.

The format of the cells was "General", I changed it to format h:mm,
but nothing changed.

But when I double click the cell and then confirm with enter the cell
gets the right format and the sum of the two cells is correct.

How can I change the whole column this way?

stremetzky

Select the data and just do a DataText To Columns, and just finish (don't
use any of the function options).

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"stremetzky" wrote in message
oups.com...
I have created .xls file from a database of another program.
But excel does not treat the data the way I want. Example:

in one cell there is a value 126:00

126 should stand for hours, 00 should stand for minutes

If I want to sum two cells I get #VALUE.

The format of the cells was "General", I changed it to format h:mm,
but nothing changed.

But when I double click the cell and then confirm with enter the cell
gets the right format and the sum of the two cells is correct.

How can I change the whole column this way?

stremetzky

Thank you! It works!

But now there is another problem. Imported values are in 000:00 form
(000 for hours and 00 for minutes). If there is less than 100 hours
the value is still not treated as [h]:mm. For example:

029:15

How can I erase the first zero ??

stremetzky

Try DataText To Columns with no delimiters or anything.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"stremetzky" wrote in message
oups.com...
Thank you! It works!

But now there is another problem. Imported values are in 000:00 form
(000 for hours and 00 for minutes). If there is less than 100 hours
the value is still not treated as [h]:mm. For example:

029:15

How can I erase the first zero ??

stremetzky