+ Reply to Thread
Results 1 to 5 of 5

Showing withOUT a dollar sign

Hybrid View

PressureDrop Showing withOUT a dollar sign 11-12-2008, 09:12 AM
oldchippy Hi, Welcome to the forum,... 11-12-2008, 09:26 AM
NBVC Click on the cell and go to... 11-12-2008, 09:26 AM
forcybo Right click on the cell and... 11-12-2008, 09:29 AM
PressureDrop I selected C13 (along with... 11-12-2008, 10:30 AM
  1. #1
    Registered User
    Join Date
    08-07-2008
    Location
    Northants, England
    Posts
    18
    Right click on the cell and go to Format Cells.

    Easiest way to do what you're asking is to change the format to Number (and select number of decimal places to zero).

  2. #2
    Registered User
    Join Date
    11-12-2008
    Location
    Atlanta, GA
    Posts
    2
    I selected C13 (along with the other ones that were showing currency instead of plain numbers), Right clicked -> Format Cells -> Number -> "Numbers" -> Decimal places "0".

    AWESOME! Just what I needed
    I was trying to make it much more difficult than that
    (was trying to combine =text "0.00" along with the existing formula)

    Thanks everyone!!!!!

+ Reply to Thread

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