Solved

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

Posted on 2013-12-08
3
515 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
  • 2
3 Comments
 
LVL 90

Accepted Solution

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

Done.

... Thinkpads_User
0
 

Author Closing Comment

by:TreadStone_IT
Comment Utility
You are a legend - thanks alot thinkpads_user   ;-)
0
 
LVL 90

Expert Comment

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

.... Thinkpads_User
0

Featured Post

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

INDEX and MATCH can be used to great effect to replace HLOOKUP and VLOOKUP as it does not have the limitation of needing the data to be sorted so that the reference value is in the first column or row. It also has the ability to perform a bi-directi…
Workbook link problems after copying tabs to a new workbook? David Miller (dlmille) Intro Have you either copied sheets to a new workbook, and after having saved and opened that workbook, you find that there are links back to the original sou…
The viewer will learn how to simulate a series of coin tosses with the rand() function and learn how to make these “tosses” depend on a predetermined probability. Flipping Coins in Excel: Enter =RAND() into cell A2: Recalculate the random variable…
This Micro Tutorial will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.

771 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

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now