Converting numbers from exponential 'E+' format
You have to watch out when using anything Polish!<bg
--
Regards,
RD
---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"E" wrote in message
...
Quite right, that did work. I shall try it on the rest of the numbers.
It did say it was Polish telephone numbers, so I tried to change that to
UK,
but that didn't work.
Many thanks.
"Jacob Skaria" wrote:
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!
|