|
|
#5
05-13-2012, 06:29 PM
|
||||
|
||||
Hi umesh,
You're not going the be able to get a display of just 1.2, or 1,200,000 without at least using a formula to change the value (eg =ROUND(numberORreference,-5) or =ROUND(numberORreference/1000000,1) either in the same cell or in another cell) .
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Change cell color everytime a value is selected in dropdown list | angelica_gloria | Excel | 4 | 01-27-2012 06:47 PM |
| number change 11 to 12 | uoume | Office | 0 | 10-30-2011 06:33 PM |
| Automatically change the value of one cell so that two other cells become equal | matthew544 | Excel | 5 | 09-18-2011 08:56 AM |
 custom number format: change thousands separator
|
Ward | Excel | 1 | 06-07-2011 08:18 PM |
| CHange colour of footer if a cell changes to red | OTPM | Excel | 0 | 05-26-2011 07:15 AM |
Windows 7 64bit 
Office 2010 32bit
Threaded Mode