in excel i cant write 12 digits numbers it shows eg 8.8445+17 like that anyone have idea please help?

Question

if bank account number has 12 digits we cant write in excel it shows some other figures

Answer 1

right click on the cell with the digits and go to format cells
go to text and click ok
done

Answer 2

Excel interprets data as a number or as a sting of characters, usually by it's context.

You have a situation where numbers are really a string (not to have math performed)

The easiest way is to add an apostrophe to the first character to signal that the rest of the characters are a string, The apostrophe will not display.

You could also use the menu Format->cells->general and select "text" to convert existing strings by selecting them first

Answer 3

Dragging the cell out can help. If it is not a number you have to do equations with, you can also define the cell as a text field and it will display the number as typed and not do the scientific notation (which is what that 8.888+10 thing is).

Answer 4

Just format the cell as text and you can type as many digits as you want

Answer 5

Drag the cell width wider. That should solve your problem

Answer 6

format/number