Posted to microsoft.public.excel.misc

external usenet poster

Posts: 40

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!

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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 07: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 10: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 01:30 PM

All times are GMT +1. The time now is 01:43 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us