Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old June 13th 09, 02:04 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Aug 2007
Posts: 40
Default Converting numbers from exponential 'E+' format

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!

  #2   Report Post  
Old June 13th 09, 02:11 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Mar 2009
Posts: 8,521
Default Converting numbers from exponential 'E+' format

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!

  #3   Report Post  
Old June 13th 09, 02:21 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Aug 2007
Posts: 40
Default Converting numbers from exponential 'E+' format

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!

  #4   Report Post  
Old June 13th 09, 03:24 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Mar 2009
Posts: 8,521
Default 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!

  #5   Report Post  
Old June 13th 09, 04:34 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Aug 2007
Posts: 40
Default Converting numbers from exponential 'E+' format

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!



  #6   Report Post  
Old June 14th 09, 02:12 AM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
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!




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Converting imported cell from exponential form Katie Mac Excel Worksheet Functions 1 February 27th 08 08:27 PM
converting telephone numbers to csv format! Rebecca Potter Excel Discussion (Misc queries) 3 August 22nd 07 11:48 AM
Converting Numbers to Date Format MB Excel Worksheet Functions 2 February 6th 07 11:49 PM
csv converting numbers to scientific format JR Excel Discussion (Misc queries) 7 June 16th 05 12:13 AM
Converting numbers to date format from csv files FiBee Excel Discussion (Misc queries) 1 January 12th 05 02:30 PM


All times are GMT +1. The time now is 07:32 PM.

Powered by vBulletin® Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
Copyright 2004-2017 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017