In 2003 excel, would it be possible to reflect data in millions (without rounding and sacrificing data accuracy). For example, I'd like to reflect 1,275,000 as 1.3, but then be able to run performance figures from this number and have them accurately report from the 1,275,000. Thank you!
Hi,
Format > Cells > Number > Custom
Enter 0,,.# in the dialogue box.
To display as 1.3M
Enter 0,,.#"M"
Rule 1: Never merge cells
Rule 2: See rule 1
"Tomorrow I'm going to be famous. All I need is a tennis racket and a hat".
Great! Thank you for the help!
merusselljr1, please take a look at the forum rules and for your next question, please select a question forum before you hit the "New thread" button.
Thread moved to Excel General.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks