Microsoft Office Forums how to change number in cell

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 05-10-2012, 05:44 PM
ubns ubns is offline how to change number in cell Windows 7 32bit how to change number in cell Office 2010 32bit
Competent Performer
how to change number in cell
 
Join Date: Apr 2012
Posts: 178
ubns is on a distinguished road
Default how to change number in cell

i have number in cell lets say --

1) 1,234,567, how can i change this number to 1,200,000

2) if i want change the values from 1,234,567 to 1.2 since (i am putting a comment --- "all values in million), can i do that?

Regards



Umesh Banga
Reply With Quote
  #2  
Old 05-11-2012, 03:51 AM
macropod's Avatar
macropod macropod is offline how to change number in cell Windows 7 64bit how to change number in cell Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 19,525
macropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to behold
Default

Hi umesh,

Do you want to change the value, or just what's displayed? Are the numbers rounded to the nearest 0.1, rounded up, or rounded down?
__________________
Cheers,
Paul Edstein
[MS MVP - Word]
Reply With Quote
  #3  
Old 05-13-2012, 06:04 PM
ubns ubns is offline how to change number in cell Windows 7 32bit how to change number in cell Office 2010 32bit
Competent Performer
how to change number in cell
 
Join Date: Apr 2012
Posts: 178
ubns is on a distinguished road
Default

I want to change just whats displayed.

I think numbers are rounded up so - if number is 162.50 or above it is showing 163 and if the number is 162.49 or below - it showing 162.

however my numbers are in millions; and for the purposes of chart and legend in the chart - I want to convert the number (at least for display purposes) from $1,623,536 to $1,623 in the chart and the legends of the chart.

I have tried using custom number format - with $#, it then changes the number from $1,623,536 to $1623. I do not know why it is not showing the comma after 1 to make the number appear like $1,623.

Please advice.

Regards

Umesh Banga
Reply With Quote
  #4  
Old 05-13-2012, 06:23 PM
macropod's Avatar
macropod macropod is offline how to change number in cell Windows 7 64bit how to change number in cell Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 19,525
macropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to behold
Default

Hi umesh,

Try a custom format as:
$0,000,
__________________
Cheers,
Paul Edstein
[MS MVP - Word]
Reply With Quote
  #5  
Old 05-13-2012, 06:29 PM
macropod's Avatar
macropod macropod is offline how to change number in cell Windows 7 64bit how to change number in cell Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 19,525
macropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to behold
Default

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
[MS MVP - Word]
Reply With Quote
  #6  
Old 05-14-2012, 04:21 PM
ubns ubns is offline how to change number in cell Windows 7 32bit how to change number in cell Office 2010 32bit
Competent Performer
how to change number in cell
 
Join Date: Apr 2012
Posts: 178
ubns is on a distinguished road
Default

Hi Paul,

it worked for me thanks. Actually i entered $#,###, instead of using 0's and I got the result I wanted. I will try using the tip related to "round" too.

Thanks a lot.
Reply With Quote
Reply

Thread Tools
Display Modes


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
how to change number in cell 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


All times are GMT -7. The time now is 04:35 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2019, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2019 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft