Solved

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

Posted on 2013-12-08
515 Views
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
• 2

LVL 90

Accepted Solution

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

Done.

0

Author Closing Comment

You are a legend - thanks alot thinkpads_user   ;-)
0

LVL 90

Expert Comment

@TreadStone_IT - Thank you, and I was happy to help.

0

## Featured Post

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…