Copy & Paste Problem

[tazhearts]

I have the following problem and was hoping some kind person out there
could help:-

I have recently discovered I can "COPY" my monthly bank statements from
my online account and "PASTE" them directly into EXCEL. This saves me
having to tpye al my transactions in manually. However there is a
problem:-

The oustanding balance on the internet is shown as follow:-

123.23 DR or 1356.56 CR etc.

This means when it is "PASTED" into EXCEL that is how it looks in each
individual cell. If I then want to perform calculations with these
numbers I can't as EXCEL does not recognise them as number. Equally I
can't format them into a currency so they look like I want:-

$123.23 or $1356.56

The only way I can convert say 123.23 DR into $123.23 (that EXCEL
recognises as a number) is to manually delete the letters from each
cell (very time consuming).

Can anyone help?

 

[Don Guillett]

try
a formula
=Left(a2,len(a2)-3))
or macro

for each c in selection
c.value=Left(c,len(c)-3))
next

 

[Guest]

format the cr and dr as numbers --- look in functions ---then once they are numbers --go to format numbers custom or tell the comp to round to 2 places ex 1356.56 will look like 1356.5611 then roun