Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Converting data format within a cell
I receive a spreadsheet with data that I need to copy and paste this in to
another spreadsheet. The data appears as follows in the following format: 1378:20:00 675:00:00 11:40:00 1:40:00 0:00 I need to write a formula or convert this into the following format: 1378.20 675.00 11.40 1.40 0.00 How can this be accomplished? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Converting data format within a cell
Hi,
I replied to your other post, if you have any problems with that one then it's probably best to continue on that post. Cheers, Sean. -- (please remember to click yes if replies you receive are helpful to you) "rylv5050" wrote: I receive a spreadsheet with data that I need to copy and paste this in to another spreadsheet. The data appears as follows in the following format: 1378:20:00 675:00:00 11:40:00 1:40:00 0:00 I need to write a formula or convert this into the following format: 1378.20 675.00 11.40 1.40 0.00 How can this be accomplished? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Converting data in General Format cell to a number | Excel Discussion (Misc queries) | |||
Converting data Format | Excel Discussion (Misc queries) | |||
Converting data to list format | Excel Discussion (Misc queries) | |||
Converting data to tally format | Excel Programming | |||
code for converting data format in another format | Excel Programming |