excel forms would not be able to import more than 15
excel forms would not be able to import more than 15,
as I enter ……123,123, turned into a format, 1.23123E +22
adjustment to tune into a show 123123123123123000000000000000
15 bit after all become 0 ~
in the table because I want to enter the bank card number to excel, but this is not very familiar with the ~
so for a simple solution ~
to format your text into a cell
– digital – text 1.23123E +22 select the cell, according to the ctr +1
category and then select the text on OK You put into a custom format, and then type it into the contents of your bank card and the median as much like a 0, such as cell 000000000000000000 text format changed to 3 good way to the floor, you have to enter the Right-lattice point – to set the cell format – digital – to enter the text of a single quotation marks and then enter a number like, try it! Input
= “[number]”
This is shown in quotation marks inside the [number]
how long can lose is set to enter text or numbers before they enter the single quotation marks;
and then re-import figures Can not modify the original figure;
Leave a Reply
You must be logged in to post a comment.