How to EXCEL in all the “*” show to show “×”,”/” “÷”
I would like to ask:How to EXCEL in all the “*” show to show “×”,”/” “÷” it? Formula and not lose the meaning of multiplication and division ah? Thank you, the first! (If the “replacement” if the two are more than symbolic multiplication and division operations will no longer have the significance of the symbols).
Hello , A very simple ah! You can do …
option in the Edit – Find / Replace, Find on the input *, to replace imported ×, the replacement of all;
/ ÷ and the same is true; ok, to see how kind! ! ! Since the invention of the computer is started up with to replace * x, / instead of the ÷.So you think excel is not provided.
Really must do so, however, because there are VBA can be programmed to excel , To a certain extent, can be done.First of all, but that is too cumbersome, but also to judge the whole table, this will result in the calculation of the efficiency of unusually low.This was followed by the not the same as * and /.There is no significance.C + +, There are heavy-duty operator, VBA did not know where you are? Only import replacement, but can not participate in the operation ×
Leave a Reply
You must be logged in to post a comment.