What is the best practice for a lookup table with numbers? Will the numbers work properly on a computer with a comma as a decimal separator as well as a computer with a period as a decimal separator? Should I format the numbers in the lookup table as text then convert using Cdbl?
store them as doubles, they are double everywhere. then when you display them, use a format command for each country.