Showing withOUT a dollar sign

**PressureDrop** · 11-12-2008, 09:12 AM

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)

**oldchippy** · 11-12-2008, 09:26 AM

Hi,

Welcome to the forum, have you tried formatting C13 to GENERAL

**NBVC** · 11-12-2008, 09:26 AM

Click on the cell and go to Format|Cells.

Select the Number tab and select General.

Click Ok.

**forcybo** · 11-12-2008, 09:29 AM

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).

**PressureDrop** · 11-12-2008, 10:30 AM

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!!!!!