...A02-10-1-1301怎么转换成000-00-00-0000格式?答:思路:定位每个“-”所在的位数,再截取相应段落,并用TEXT来控制输出位数。B1=LEFT(A1,3)&"-"&TEXT(MID(A1,5,FIND("@",SUBSTITUTE(A1,"-","@",2))-5),"00")&"-"&TEXT(MID(A1,FIND("@",SUBSTITUTE(A1,"-","@",2))+1,FIND("@",SUBSTITUTE(A1,"-","@",3))-FIND("@",...
GBA怎么金手指?在哪输入代码答:格式的金手指选择"金手指(Game Shark)",输入下方的空白处 选择"确定"回到游戏 [HP]ON=2423C,E7,3 [能力值1]ON=2423E,E7,3 [能力值2] FFFD;ON=24240,E7,3 [能力值3]ON=24242,E7,3 [能力值4]ON=24244,E7,3 [能力值5]ON=24246,E7,3 [第一技能PP]ON=227F0,63;22B30,63;23...