how to input a 12 digit number into a cell

  • Thread starter Thread starter jedi
  • Start date Start date
J

jedi

Hi i am pretty new to excel but here goes. The problem I am having is
when I try to input a 12 digit number into an excel cell i get
*1.03001E+11 *instead of 1*03000568221* 10 digits seem to go in ok. I
copy and paste this 12 digit number. any ideas what this can be thanks
in advance.
 
Hi Jedi.

Change the cell Format from General to zero (0) either by nymber fomat
or custom


VBA Noob
 
I would try entering a leading apostrophe to input the value as
TEXT..........then if it took it ok, convert it to a number if needed.

Vaya con Dios,
Chuck, CABGx3
 
CLR said:
I would try entering a leading apostrophe to input the value as
TEXT..........then if it took it ok, convert it to a number if needed.

Vaya con Dios,
Chuck, CABGx3



message
Click to expand...


Hi i put a commer infront of the digits and it now displays the whole
12 digit number with the commer however. This is better that what I had
thou, thats again
 
CLR said:
I would try entering a leading apostrophe to input the value as
TEXT..........then if it took it ok, convert it to a number if needed.

Vaya con Dios,
Chuck, CABGx3



message
Click to expand...


Hi i put a commer infront of the digits and it now displays the whole
12 digit number with the commer however. This is better that what I had
thou, thanks again
 
If you use a leading apostrophe instead, or pre-format the cell for TEXT,
then only your input characters would show in the cell and the
printout.........

Vaya con Dios,
Chuck, CABGx3
 
Just to update I copied and and did a paste special and choose text and
it went in ok? I`ll have to stick with that for now
 
Hi jedi,

you can also have 12 (or more) digit number stored as number, so that you
can easily calculate with them if needed.
You just need to format cell by choosing Format - Cells. On Number tab
select Category "Custom" and in "type" type 12 zeros (for 12 digit number to
display). If you have also numbers with less digits, it is better to type the
following custom cell format: ###########0

# means display nothing if there is nothing
0 means display 0 if there is nothing (you get leading zeros if you have
less digits as defined in cell format)

Regards,
Nika Lampe

"jedi" je napisal:
 
Back
Top