| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Replace numbers with time
I downloaded "sunrise/sunset" data into an Excel 2003 spreadhseet but the
times came as numbers, like "1622". I want to convert that to "16:22" but the format cell option does not work. It converts it to a date and a time (noon). Since the times change every few cells, search and replace is inefficient. I tried searching for 16** and replacing them with 16:** but Excel took that liberally. Is there a wildcard command to replace these numbers: 1622, 1623, 1624 with 16:22, 16:23, 16:24? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| replace letters for numbers | Excel Discussion (Misc queries) | |||
| replace numbers with X | Excel Discussion (Misc queries) | |||
| How do I replace numbers in a value NOT a formula? | Excel Discussion (Misc queries) | |||
| greater than replace numbers | Excel Worksheet Functions | |||
| How to Replace numbers and text with numbers only? | Excel Worksheet Functions | |||
Threaded Mode
