To display number in text format in cells
Change the cell format to either:
Number
Accounting
or
Currency.
--
HTH,
RD
---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Man T" wrote in message
...
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?
|