Excel Macro to Prevent Excel from Removing Leading and Trailing Zeros in a single Cell or Selection of Cells

Posted on Sat 23 June 2012 in General

With use of macro given below you can apply ="cell_value" on any selection.

Solution is:

[caption id="attachment_397" align="alignleft" width="460"]macro for preventing leading and trailling zeros in excel macro for preventing leading and Trailing zeros in excel[/caption]

excel leading zero macro Trailing zero