formating cells

S

stremetzky

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
 
B

Bob Phillips

Select the data and just do a Data>Text 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)
 
S

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
 
B

Bob Phillips

Try Data>Text To Columns with no delimiters or anything.

--
HTH

Bob

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