R
Rob
Hi,
Using Excel 2000
I have spreadsheet that uses text entries to do a Vlookup, the look up range
has text in the format of 6 characters albeit they look like numbers with
leading zeros eg. '000100. The entry that I enter if '000100 returns the
correct result. However, when others enter they tend to just enter '100
which doesn't match. I therefore thought that if I could check the length
of their entry, I could fill with leading zeros to make it 6 characters
long.
Having tried to do this with validation, I'm now thinking this is a change
cell piece of code.
Any pointers of sample code would be appreciated.
Thank you, Rob
Using Excel 2000
I have spreadsheet that uses text entries to do a Vlookup, the look up range
has text in the format of 6 characters albeit they look like numbers with
leading zeros eg. '000100. The entry that I enter if '000100 returns the
correct result. However, when others enter they tend to just enter '100
which doesn't match. I therefore thought that if I could check the length
of their entry, I could fill with leading zeros to make it 6 characters
long.
Having tried to do this with validation, I'm now thinking this is a change
cell piece of code.
Any pointers of sample code would be appreciated.
Thank you, Rob