It's stored as text.
Write 1 in any cell.
Copy that cell
Select column with times
Paste spetial -> Multiply
Format column as time
Delete cell with number 1
It's stored as text.
Write 1 in any cell.
Copy that cell
Select column with times
Paste spetial -> Multiply
Format column as time
Delete cell with number 1
Never use Merged Cells in Excel
wow... nice one mate. thank you
do you know why it's stored as text? what is the benefit of it?
Also is this only one way hot to do it? i mean is there any chance to set criteria and than just pasted in?
Anyway thanks a lot again !!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks