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