Link to home
Start Free TrialLog in
Avatar of Jim Metcalf
Jim MetcalfFlag for United States of America

asked on

question about excel functionality

I often have to do repetitive processes on excel spreadsheets that are not in the exact same format so im not sure if a type of macro would work.

the column in question is populated with 8 ta 10 digits of numeric data.  i like a function to insert a row to the right of this column and format all the numeric data to a 10 digit number with padded zero's if needed.

I need to be able to complete this in any spreadsheet i am working on at anytime.
ASKER CERTIFIED SOLUTION
Avatar of Wayne Taylor (webtubbs)
Wayne Taylor (webtubbs)
Flag of Australia image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Jim Metcalf

ASKER

Thanks guys-
im sorry i took so long to get back to you