"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.