how do I change number format from 3,999.89 to 399989

's Computer Specifications

's Computer Specifications

You cannot format that number in the manner you ask.

Multiply the cell by 100 to get your wish.

Enter 100 in an empty cell.

Copy that cell then select the cells with numbers and paste
special>multiply>esc

Delete cell with 100

Gord Dibben MS Excel MVP

On Wed, 7 Apr 2010 20:48:01 -0700, MichelleT
<(E-Mail Removed)> wrote:

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
change a text format to number format	ferde	Microsoft Access	6	20th Mar 2010 03:34 PM
Change number format from text to number?	Scot	Microsoft Excel New Users	2	1st Dec 2005 04:15 PM
Change number (in text format) to numeric format	=?Utf-8?B?UGFt?=	Microsoft Excel Misc	5	24th Oct 2005 07:45 PM
How do i change numbers in text format to number format?	=?Utf-8?B?R3JlZw==?=	Microsoft Excel New Users	1	14th Dec 2004 05:22 PM
make table query - change number format to text format	Mark	Microsoft Access Queries	1	13th Dec 2003 12:10 AM