Results 1 to 14 of 14

Formula changes within cell automatically

Threaded View

  1. #1
    Registered User
    Join Date
    10-22-2012
    Location
    Long Island, New York
    MS-Off Ver
    Excel 2007/2010
    Posts
    5

    Red face Formula changes within cell automatically

    Hi. I entered the following into a cell in a worksheet I did not create:

    +4500/9*12

    excel automatically changed the formula to read as =500*12

    While the answer is still correct, I need the typed values to remain as they were entered in the cell. How do I change the formatting to correct this? When opening a new spreadsheet I do not encounter this issue.

    Thanks so much!
    Last edited by aminsky; 10-23-2012 at 10:37 PM.

Thread Information

Users Browsing this Thread

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

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