Solved

Excel 2007 How to convert number in cell ie 100 to 1 OR 745 to 7.45

Posted on 2013-12-08
3
612 Views
Last Modified: 2013-12-09
Hi our accounts depart have asked for my help and excel is my weakness. Hopefully someone knows here.

They need a formular to move the "." 2 positions to the left, ie
convert:
100 to 1.00
278 to 2.78
2988 to 29.88

Any ideas anyone?
Many thanks
String
0
Comment
Question by:TreadStone_IT
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 95

Accepted Solution

by:
John Hurst earned 500 total points
ID: 39705189
Simply divide the number by 100.   B1 = @ROUND(A1/100,2)

Done.

... Thinkpads_User
0
 

Author Closing Comment

by:TreadStone_IT
ID: 39705217
You are a legend - thanks alot thinkpads_user   ;-)
0
 
LVL 95

Expert Comment

by:John Hurst
ID: 39705820
@TreadStone_IT - Thank you, and I was happy to help.

.... Thinkpads_User
0

Featured Post

Salesforce Has Never Been Easier

Improve and reinforce salesforce training & adoption using WalkMe's digital adoption platform. Start saving on costly employee training by creating fast intuitive Walk-Thrus for Salesforce. Claim your Free Account Now

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Improved? Move/Copy Add-in Replacement - How to avoid the annoying, “A formula or sheet you want to move or copy contains the name XXX, which already exists on the destination worksheet.” David Miller (dlmille)  It was one of those days… I wa…
Some code to ensure data integrity when using macros within Excel. Also included code that helps secure your data within an Excel workbook.
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
This Micro Tutorial demonstrate the bugs in Microsoft Excel for Mac with Pivot Charts.

752 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question