I choose a regular scientific notation will emerge, choose into text, prompt the data stored in the form of text, graph A1! A1=A2, the picture is how the input? I want to convert A2 to A1 or A1 into A2 should how make

CodePudding user response:

The cursor point A1 is look at the formula bar and cell properties, in addition to the first type set to text input data again, can also add a English in front of the input content as text behind the single quote character indicate that

CodePudding user response:

C1: input formula

="A1 length" & amp; Len (a1) & amp;" , B1 length "& amp; Len (b1)