Hi Roz


You would not be able to do that within one column in any orderly fashion.

You could do it over 3 or 4 Columns. Do you wish to do that?

Also , are you saying, that your wholesale unit prices could be in Euro,
Pounds or Dollars and you would like the facility to show all stock in any
one Currency.

If you can answer these questions then we could move forward

Best

Stewart


"Roz D" wrote:

I have a column titled Unit Price, I need to be able to find a way of firstly
choosing whether it is n £, $ or Euros and calcluating the exchange rate
accordingly, I will also need to be able to edit the exchange rate
periodically. Secondly the same Pcolumn needs to have an option between 2
sets of pricing: List price and Discounted Price. I have a limited amount of
experience, so any suggestions would be welcome.
--
R