excel vba - format decimal places

[chief]

I have a list of prices form D2:E1500 that have gone wacko and I canno
get them to re-format. The prices were put through a previous formul
and then copy and pasted into this sheet, so each one reads ex
5.509475034 instead of just $5.51. How can I make it so that I ca
format all these numbers to be ONLY two decimal places so that I won'
have to go in and retype all 1500 of them?

Thanks yo

 

[Rollin_Again]

Try the following:

Place the number *1* in any empty cell on the sheet. After enterin
the number, right click the cell and select "Copy"
Next right-click the cell or range of cells with the misformatted dat
and choose "Paste Special" and select the radio option button labele
"Multiply" and click OK.

Now try to re-format the cell.


Rolli

 

[Bob Phillips]

If all you want is the presentation, go and format as currency.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)