I am using Excel 97 and I need to do the following:
I have a column of values that look like this:
12.23
15.55
14.15 etc
I need to format each of them to look like this:
000000001223
000000001555
000000001415
Any help would be greatly appreciated. thanks
I have a column of values that look like this:
12.23
15.55
14.15 etc
I need to format each of them to look like this:
000000001223
000000001555
000000001415
Any help would be greatly appreciated. thanks