Excel Help Please!!

Bohatir · 05-09-2006, 08:49 PM

I am very very very NOOB to excel. I need help making settings that will make my numbers show up with the zero's after the decimal point. Like right now, I put in $30.00 and after I hit Enter, it just shows $30.

I am in huge hurry, please help

**devil lady** · 05-09-2006, 11:06 PM

You need to right click the column or cells you want to show .00 and choose currency, decimal places 2. Hope that helps.

PRP · 05-10-2006, 06:53 AM

Hello,
To convert to two digits after decimals, select the numbers and then go to "FORMAT-CELLS-NUMBERS-CATEGORY-CURRENCY" , now in Decimal Places enter "2" which will make two digits after decimal.
Cheers!!!

05-09-2006, 08:49 PM	#1 (permalink)
Bohatir Registered User Join Date: May 2006 Posts: 2 OS: Windows XP Pro	Excel Help Please!! I am very very very NOOB to excel. I need help making settings that will make my numbers show up with the zero's after the decimal point. Like right now, I put in $30.00 and after I hit Enter, it just shows $30. I am in huge hurry, please help

05-09-2006, 11:06 PM	#2 (permalink)
devil lady Tech, Design Team Join Date: Sep 2005 Location: Tasmania, Australia Posts: 962 OS: XP SP2 My System	You need to right click the column or cells you want to show .00 and choose currency, decimal places 2. Hope that helps. __________________ . HiJackThis Everest Home Edition Ad Aware Spybot S & D Ewido online scan Spyware Blaster

05-10-2006, 06:53 AM	#3 (permalink)
PRP Registered User Join Date: May 2006 Posts: 86 OS: xp	Hello!!! Hello, To convert to two digits after decimals, select the numbers and then go to "FORMAT-CELLS-NUMBERS-CATEGORY-CURRENCY" , now in Decimal Places enter "2" which will make two digits after decimal. Cheers!!!