FIND & REPLACE ISSUE
Thanks to all!
"Dave Peterson" wrote:
Can you change them to number format?
If yes...
Put 1000 in an empty cell.
edit|copy that cell
select your range to fix
Edit|paste special|multiply
clear the helper cell with 1000 in it.
Format the fixed range to show leading 0's:
Select the range
format|cells|number tab|custom category
00000
(or as many as you need)
William wrote:
I have a colomn with 2-digits (currently text format):
03
04
10
20
. . . etc.
I'd like to do a find and replace which adds three zeroes to the end, so
that I get this:
03000
04000
10000
20000
Is it possible?
Thanks
--
William
--
Dave Peterson
|