Hi im running excel 2003 on a windows xp pc, and when i drag down a simple formulae to cover several rows (=A1*B1) for example, all the boxes using pounds work fine but all the rows with dollars in just generate the value error. Ive tried formatting the box as a currency cell for dollars, but it didnt work. Can anyone help?