| Home |
| Search |
| Today's Posts |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Convert Text Time to Excel Time
Actually one minor suggestion
Instead of copying a cell with number 1 in it, selecting the range to convert, and using Edit, Paste Special Multiply use Copy an empty cell then select the range to convert, Edit, Paste Special Add the difference is that empty cells do not become 0 but remain empty. --- HTH, David McRitchie, Microsoft MVP - Excel My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "David McRitchie" wrote... Hi Jean-Guy, and William (cc: to William) Very sorry about that, don't know what I was thinking of. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do i convert unix time to Julian time in excel? | Excel Discussion (Misc queries) | |||
| Excel data in text, wont update to time format | Excel Discussion (Misc queries) | |||
| Convert Text to Columns with Excel 2007 beta does not work well | Excel Worksheet Functions | |||
| How do I convert a time to text format. | Excel Discussion (Misc queries) | |||
| Text to time convert | Excel Discussion (Misc queries) | |||
Threaded Mode
