To display number in text format in cells

  • Thread starter Thread starter Man T
  • Start date Start date
M

Man T

I have a sequence of digits like
5026555306553

I entered in a cell and when the cursor left the cell it displays as
5.02656E+12

How do I set the cell or the whole spreadsheet to display as text rather
than this format?
 
Hi,

Careful here, if you paste a number from a range onto a cell that is
formatted as text the number will be stored as a number not as text, unless
you tell it to paste values or paste formulas or basically you tell it to
paste without formatting.
 
I'm assuming, perhaps incorrectly, that the OP is *primarily* concerned with
displaying *all* the digits.

Off the top of my head, I can't immediately see a difference between the 2,
except for default left or right justification.
Or ... maybe not totaling with the Sum() function.

Can you think of some others?
--

Regards,

RD
-----------------------------------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
-----------------------------------------------------------------------------------------------

message Hi,

Careful here, if you paste a number from a range onto a cell that is
formatted as text the number will be stored as a number not as text, unless
you tell it to paste values or paste formulas or basically you tell it to
paste without formatting.
 
I'm assuming, perhaps incorrectly, that the OP is *primarily* concerned
Yes, I just want to display the whole string of numbers as string or text
but not the exponential format.

The reason is the cell will contain a barcode or serial number that is all
numerics.
 
The General format will default to scientific notation when the digits
exceed 11.

Thanks for the feed-back.
--

Regards,

RD
-----------------------------------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
-----------------------------------------------------------------------------------------------


Yes, I just want to display the whole string of numbers as string or text
but not the exponential format.

The reason is the cell will contain a barcode or serial number that is all
numerics.
 
Back
Top