100M = 100,000,000; 100k = 100,000
"jomni" wrote
in message ...
I want to make a macro where you just input 100m and the data
automatically converts to 100,000,000, etc. Anyone has some leads?
Examples?
Hi Jomni,
Shouldn't be too difficult.
I would suggest you use a worksheet_change event to trigger a check on
the taget cell (or cells) and pattern match where the entry is a text
string of
the form "[N]m" where [N] is one or more numeric digits.
HTH,
Alan.
|