Share via

Input whole number, Output number divided by 100

Anonymous
2011-11-05T04:37:42+00:00

Good Morning!

Here is my problem:

input in the cell: 123

output in the cell: 1.23

input: 1

output: 0.01

May I have your help me to solve the matter?

Thank you!

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

  1. Anonymous
    2011-11-05T13:37:26+00:00

    You have the Fixed Decimal Setting enabled. This feature is intended for circumstances in which you are entering a large number of values with decimal points. It automatically inserts the decimal point for you. Go to the File menu, choose Options then the Advanced page. There, scroll down to Editing Options and uncheck the "Automatically insert a decimal point" option. It is this setting that enables and disables the automatic insertion of a decimal point when you enter a number in a cell.

    If this option is checked and in effect, you should see "Fixed Decimal" in th lower left hand side of the Excel application windows, just below the worksheet tabs.

    2 people found this answer helpful.
    0 comments

4 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2011-11-19T04:27:53+00:00

    Thank you!

    My problem is solved.

    Francesco

    0 comments
  2. Anonymous
    2011-11-05T17:21:14+00:00

    My first interpretation was same as yours

    I think the problem with interpretting this question lies in the subject line... it looks like it is describing what the OP wants to do.

    0 comments
  3. Anonymous
    2011-11-05T15:52:15+00:00

    My first interpretation was same as yours but on second thoughts - Mr Pearson is right.

    Hope FrancescoCimini settles it :-)

    0 comments
  4. Anonymous
    2011-11-05T08:23:25+00:00

    After reading Chip's response, it looks like I misread your question. I thought you were asking how to do what you posted whereas he, correcty I think, interpretted it as you were getting the results you posted now and wanted it to stop. So you can probably ignore my response below (unless Chip is wrong and I was right initially<g>).

    Right click the name tab at the bottom of the worksheet that you want to have this functionality on, select View Code on the popup menu that appears and then copy/paste this code into the code window that opened up...Private Sub Worksheet_Change(ByVal Target As Range)  Dim Cell As Range  If Not Intersect(Target, Range("A:B")) Is Nothing Then    Application.EnableEvents = False    For Each Cell In Target      If IsNumeric(Cell.Value) Then Cell.Value = Cell.Value / 100    Next    Application.EnableEvents = True  End IfEnd SubThe only change you have to make is inside the Range call... as written, the code will make the requested changes for any cell in Columns A:B... change the "A:B" to any valid range of cells and the code will be restricted to that range of cells only (all cells outside the specified range will function normally).

    0 comments