Results 1 to 5 of 5

Showing withOUT a dollar sign

Threaded 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
    11-12-2008
    Location
    Atlanta, GA
    Posts
    2

    Showing withOUT a dollar sign

    Good morning all. I am a new user both to Excel and these forums, but I am very glad they both exist!!!

    What I have is this (it is C13 for those playing at home):
    =ROUNDUP(8000/C11,0)
    What it shows is this: $20.00
    What I want it to show is this: 20

    How do I make it show no dollar sign and no decimal points?

    Please help (and go easy on me, I have been searching and trying things for 2 hours now).

    Thanks in advance!

    In case it matters (for those playing at home) here are the related cells:
    B3 27.19
    B8 =+B6-B7
    C10 =B3*20
    C11 =C10*75%
    C12 =B8*20
    C13 =ROUNDUP(8000/C11,0)
    Last edited by oldchippy; 11-12-2008 at 10:58 AM.

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