Is there and fromula or macro to keep only one zero after the N.
sample: in column A at the last row the N# like belowe:
N0069, N00125, N0002509 ,N002609 or N000023004
just want to keep one zero between the N to the number.