Numbers to Text

  • Thread starter Thread starter Nigel
  • Start date Start date
N

Nigel

I have a column on 15 digit numbers that have been entered as a number
format. I need to have them displayed as text format in another spreadsheet
but when they are copied and changed to text, they become displayed as
scientififc notation. Is there a way to have my numbers as text?

Thank you
 
Hi Gary

Thanks for your reply. I've already tried that, even paste special the
values, but it does not work as I need to have the numbers in a text format.

Thanks
 
Back
Top