Solved

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

Posted on 2013-12-08
3
560 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 93

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 93

Expert Comment

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

.... Thinkpads_User
0

Featured Post

NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

Question has a verified solution.

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

A little background as to how I came to I design this code: Around 5 years ago I designed an add-in that formatted Excel files to a corporate standard, applying different cell colours and font type depending on whether the cells contained inputs,…
Convert between Excel file formats (.XLS, .XLSX, .XLSM) with/without macro option David Miller (dlmille) Intro Over this past Fall, I've had the opportunity to see several similar requests and have developed a couple related solutions associate…
This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

777 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