View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
RagDyeR RagDyeR is offline
external usenet poster
 
Posts: 3,572
Default 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!