How can I append a number to the beginning of a number -- and then drag it down.
Hi
Have Excel Office 2007. Windows 7.
I have a column of numbers (can be text or number format), like this:
2123
2121
3123
I want to add a "zero" to the beginning of each of those numbers, such
02123
02121
03123
What formula can I use to do this.
Rowby
Have Excel Office 2007. Windows 7.
I have a column of numbers (can be text or number format), like this:
2123
2121
3123
I want to add a "zero" to the beginning of each of those numbers, such
02123
02121
03123
What formula can I use to do this.
Rowby
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I went with the 000000 formatting in this situation.
Rowby