+ Reply to Thread
Results 1 to 2 of 2

Format a number into a percentage without changing the number on the formula bar

  1. #1
    Registered User
    Join Date
    09-10-2023
    Location
    Italy, Milan
    MS-Off Ver
    Excel 2021
    Posts
    7

    Format a number into a percentage without changing the number on the formula bar

    Hi, I have a problem.
    I have a cell with a number like 0.48412 and I right click --> format cells --> Percentage (decimal places:2).
    As a result I get 48.41% on the cell as expected but on the formula bar I get 48.412%.
    Instead on the formula bar I would like to have the NOT formatted decimal number 0.48412.

    I thought that formatting a cell was just for a visual purposes, however on my excel it actually changes the number on the formula bar from 0.48412 to 48.412%.

    Is there a way to prevent this to happen?

    Thank you

  2. #2
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,463

    Re: Format a number into a percentage without changing the number on the formula bar

    Hi,
    why is it important that the number appear as 0,... on the formula bar? The underlying stays the same..

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Code to get number format in percentage with IF condition
    By RAJESH SHAH in forum Excel Programming / VBA / Macros
    Replies: 18
    Last Post: 03-17-2023, 04:19 PM
  2. Replies: 4
    Last Post: 03-05-2023, 03:23 PM
  3. Can I format a number to a percentage of a previous cell?
    By everlast1910 in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 06-10-2017, 05:46 AM
  4. [SOLVED] Problem with formula changing the cel number format
    By SL_Mills in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-07-2016, 02:19 PM
  5. Need formula or code to convert number(s) from custom format to number format
    By tuongtu3 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 01-12-2015, 07:44 PM
  6. How to format percentage column as a number format
    By acsishere in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 05-25-2008, 04:12 PM
  7. changing a cell to number format using a formula
    By pmetzak in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-22-2008, 02:56 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1