Quote:
Originally Posted by Colin Legg
Hi,
As far as I know you can't do this with number formats alone. You could convert the value to uppercase using the UPPER() function in a formula though.
|
Yes, it does when there is no number format. But my data is formatted, the VBA codes in the attached file do not work at all. Please kindly take a look at the file below.
test.xlsm
Many thanks!