Converting numbers from exponential 'E+' format
How is it displayed when you tried the below..
Select ColumnFormatCellsSelect Special and choose OR select CustomIn
Type: enter 11 zeroes
If this post helps click Yes
---------------
Jacob Skaria
"E" wrote:
The number is in the text box correctly, so is it not a formatting issue to
make it display in full?
"Jacob Skaria" wrote:
Select Column. From menu DataText to ColumnsNextNextSelect TextFinish
OR
Select ColumnFormatCellsSelect Special and choose OR select CustomIn
Type: enter 11 zeroes
--
If this post helps click Yes
---------------
Jacob Skaria
"E" wrote:
I have phone numbers from a report which are in the exponential format, eg,
4.5513E+11. I want these to show as 11 digit numbers. I am sure this must be
straightforward!
|