Solved

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

Posted on 2013-12-08
3
643 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 96

Accepted Solution

by:
Experienced Member 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 96

Expert Comment

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

.... Thinkpads_User
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.

623 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