Usable format
 

Hi all,

I have just received a large data dump and need to convert the following
dollar amounts into a usable format.

0000137708.64+
0000020138.12+
0000081434.24+
0000093316.26+
0000054740.17+

what is the clever way?

Thanks in Advance,

Matt

Usable format
 

Paste them into A1 in an Excel file...
Choose Data-Text to column...
Choose Fixed width
Click Next
Separate the column just before the + sign
Click FINISH

"veryeavy" wrote:

Hi all,

I have just received a large data dump and need to convert the following
dollar amounts into a usable format.

0000137708.64+
0000020138.12+
0000081434.24+
0000093316.26+
0000054740.17+

what is the clever way?

Thanks in Advance,

Matt