johnniericoh
Member
when entering 11 numbers in cell say 11111111111 it is acceptable but if I enter 12 numbers the cell reads 1.11111E+11
Why
Why
Last edited:
What??
when entering 11 numbers in cell say 11111111111 it is acceptable but if I enter 12 numbers the cell reads 1.11111E+11
Why
thanks for reply but could you be more specific ie which tool bar etcjust click on the , on the tool bar and will correct (or change formats in number formatting)
You have to change for cell format from "general" to "number". You can do this by right clicking on thr cell, choosing format cell and changing it there, or dependent on thr version, there is an option in the toolbar (can't remember which tab)
Sent from my SM-G930F using Tapatalk