Prevent scientific display

  • Thread starter Thread starter scele
  • Start date Start date
S

scele

I have a lot of entries (personal identification numbers) and all o
them are formatted as NUMBER. Now, I must convert it to TEXT format
but when I convert them, they change to scientific numbers. I know tha
value in the cells is the same, but please, is there any way to kee
displaying cells as they are (eleven-digits), even if they are in TEX
format.

Sorry for my bad english.
Iva
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Reading CSV with numbers in text format, Excel automatically convertsto scientific notation 1
Question re Custom Number Formats 3
unwanted scientific notation 3
'Text' formatted cells displaying numbers in scientific format 13
turn off scientific notation? 3
Why can't I format digits as text? 4
Conditional custom number format? 5
Prevent scientific formatting when creating excel sheet from vbscr 5

Back
Top