A andysa Nov 18, 2003 #1 Does anybody know how I can blank out the first four numbers in a box with #### (eg 2323534534 would read ####534534). Thanks
Does anybody know how I can blank out the first four numbers in a box with #### (eg 2323534534 would read ####534534). Thanks
F Freemini Nov 18, 2003 #2 One way to do this Assuming your number 2323534534 is in A1, enter the following in cell B1 ="####"&RIGHT(A1,6) This will give B1= ####534534 Hope this helps Mike
One way to do this Assuming your number 2323534534 is in A1, enter the following in cell B1 ="####"&RIGHT(A1,6) This will give B1= ####534534 Hope this helps Mike
K Kevin B Nov 19, 2003 #3 One way is ="####" & RIGHT(A1,LEN(A1)-4) Assuming your original number is in cell A1
