ExcelVBA-In a column, change only cells that
Closed
Khennjo
-
Jan 20, 2010 at 11:23 PM
venkat1926 Posts 1864 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Jan 21, 2010 at 05:47 AM
venkat1926 Posts 1864 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Jan 21, 2010 at 05:47 AM
Related:
- ExcelVBA-In a column, change only cells that
- How to change date format in excel - Guide
- Change computer name cmd - Guide
- Based on the values in cells b77 b81 ✓ - Excel Forum
- How to change language in idm - Guide
- How to change author in excel - Guide
1 reply
venkat1926
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
810
Jan 21, 2010 at 05:47 AM
Jan 21, 2010 at 05:47 AM
suppose the data
0
1
0
7
2
0
31
10
0
1
in from A2 down. A1 is having column heading.
in B2 copy paste this formula
=IF(LEN(A2)=1,0&A2,A2)
copy B2 down.
0
1
0
7
2
0
31
10
0
1
in from A2 down. A1 is having column heading.
in B2 copy paste this formula
=IF(LEN(A2)=1,0&A2,A2)
copy B2 down.