-
VBA convert string issue
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules