Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 874
  • Last Modified:

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

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
TreadStone_IT
Asked:
TreadStone_IT
  • 2
1 Solution
 
JohnBusiness Consultant (Owner)Commented:
Simply divide the number by 100.   B1 = @ROUND(A1/100,2)

Done.

... Thinkpads_User
0
 
TreadStone_ITAuthor Commented:
You are a legend - thanks alot thinkpads_user   ;-)
0
 
JohnBusiness Consultant (Owner)Commented:
@TreadStone_IT - Thank you, and I was happy to help.

.... Thinkpads_User
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now