PC Review


Reply
Thread Tools Rate Thread

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

 
 
MichelleT
Guest
Posts: n/a
 
      8th Apr 2010

 
Reply With Quote
 
 
 
 
Gord Dibben
Guest
Posts: n/a
 
      8th Apr 2010
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:


 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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


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


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 10:30 PM.