Wednesday, July 20, 2011

Convert numbers in millions.... "#,,.00"

Select Cell (numbers you have typed)----> press Ctrl + 1 ----> Custom -----> in "Type"

"#,,.00"

you can see your numebrs are converted in million without using any formula or disturbing any values

No comments:

Post a Comment