MS Excel 2010 - Is it possible to format a cell so it displays a number as
time format?
My question is:
Is it possible to format a cell so it displays a number as time format?
For example, I want type 1445 and I would like it to be displayed as 14:45
in time format.
The importat thing here is the "time format" part. I can format the cell
with ##":"##, but this doesn't allow me to use the value like the time
format.
No comments:
Post a Comment