Checksum macro

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

a924fan@yahoo.com - 22 Sep 2007 18:58 GMT

I get this output from my checsum calculatios FEF01. I would like to
trim the output to 4 digits to look like a more conventional checksum.
ie EFO1. Any way to mask out the lower 4 digits?

Reply to this Message

Dave Peterson - 22 Sep 2007 20:19 GMT

Maybe
=right(a1,4)
if A1 held the checksum.

or maybe
=right(yourchecksumformula,4)

> I get this output from my checsum calculatios FEF01. I would like to
> trim the output to 4 digits to look like a more conventional checksum.
> ie EFO1. Any way to mask out the lower 4 digits?

Signature

Dave Peterson

Reply to this Message

a924fan@yahoo.com - 22 Sep 2007 23:03 GMT

My man Dave! You are 2 for 2. I should put you on salary.........

Reply to this Message