Hi all, sorry if you all see the title and groan but im banging my head against a wall here. Whats happening is we have decimals that are formatted in a ??/?? format in excel. This is fine, however certain values will default to undesired ones eg 6/4 goes to 3/2. to combat this the cell automatically changes 3/2 to "6/4".

So in the vba which processes this value we use cdbl("6/4") however this always fails with a type mismatch error.

I have written a function that returns the decimal value (1.5) but i also need to keep the original formatting!!


Any suggestions?

Thanks in advance