numbers to characters
This simple VBA code should do it Could make it a Event producre or just add a macro button. It assumes data starts in "A1". Sub Remove_zero() ' Range("A1").Select Selection.CurrentRegion.Select Selection.Replace What:="0", Replacement:="" Range("A1").Select End Sub VBA Noob -- VBA Noob ------------------------------------------------------------------------ VBA Noob's Profile: http://www.excelforum.com/member.php...o&userid=33833 View this thread: http://www.excelforum.com/showthread...hreadid=563972 |
All times are GMT +1. The time now is 03:29 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com