[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

[Gary''s Student]

After the copy:

Format Cells... Number Custom 000000000000000
--
Gary''s Student - gsnu200791

[Janusz Pawlinka]

U¿ytkownik "Nigel" napisa³ w wiadomo¶ci
...
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

have you tried (in additional column i.e in cell C1 and down below):

=TEXT(B1, "0")

where B is your column with 15 digit numbers
--
--
==============================
Janusz Pawlinka

[Nigel]

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

"Gary''s Student" wrote:

After the copy:

Format Cells... Number Custom 000000000000000
--
Gary''s Student - gsnu200791

[Nigel]

Hi Janusz

Thanks for your reply, it works!

Thank you

"Janusz Pawlinka" wrote:



U¿ytkownik "Nigel" napisa³ w wiadomo¶ci
...
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

have you tried (in additional column i.e in cell C1 and down below):

=TEXT(B1, "0")

where B is your column with 15 digit numbers
--
--
==============================
Janusz Pawlinka