Don't assume that other people have read your earlier posts.

It strikes me that a Data Validation drop-down in conjunction with
VLOOKUP would enable you achieve what you want. Set up a table
somewhere with the FULL range and the number it gets converted into,
and then you could set your DV drop-down to point to the first column
of your table and use VLOOKUP to return the second column.

Hope this helps.

Pete

On Nov 25, 7:46 pm, Gmata wrote:
Ok so i got the first part on how to use the VLOOKUP formula thanks to Alan,
now how about adding a range in there how could i do that.
for example:
i type i get
.1 to 1.50 2.95
23 to 25 40.0

Thanks