what should I do to show me the correct number and not formulated

3

I have a cell formulated with an SI and the result must be a number, I went to cell format and select number format.

Now from word I am trying to print on a pre printed form, so scan the form and import it in word and there I assign the excel fields by means of correspondence, it brings me the fields bn however it does not show me the number as it should be if it does not show me something like that 112234566 + E1

What should I do to show me the correct number and not formulated.

Try to place the box in text format in the excel but it does not work.

    
asked by Jeferson Martinez 28.06.2016 в 19:31
source

1 answer

1

In the formula cell I must press F9 and automatically convert the formula to a value.

    
answered by 12.07.2016 в 19:48