i have a spread sheet with different currencies and I want to know if i can
format one column so that the different currency symbol comes on an amount i
enter. i know i can format from the format box but was wonder if there is
something i can enter so that the currency symbol comes up automatically. i
have a lookup table on sheet two with the currency symbol against 20
products. can i incorporate this currency symbol in the cell when i enter the
amount on sheet 1. thank you for your help