Currency Formatting Problem

JazzyJen · Apr 12th, 2002, 09:25 AM

For the life of me, I can not figure out how to give a currency format to a cell. I have used Format>Cells>Currency, but it is not showing the numbers correctly.

I want to be able to type 12550 in a cell and have it appear as 125.50

I do not want to type a decimal, and a dollar symbol would be lovely, but it's not necessary.

Any help or suggestions would be appreciated!

AJ · Apr 12th, 2002, 09:31 AM

I reckon the problem is that the Format>Cells>Currency is expecting you to type in dollars, whereas you're actually typing in cents.
Why not type in your numbers 12250 in one column (say A) and in the column beside it divide it by 100 to create the decimal point
=A1/100
and then format that. Format>Cells>Currency will put it the dollar.

Rgds
AJ

Von Pookie · Apr 12th, 2002, 10:03 AM

Go to Tools/Options/Edit tab.

Select Fixed decimals, set it to 2 and click ok to apply changes.

Now if you type in 12550 without the decimal, it will show as 125.50, without having to divide it.

Hope this helps,

_________________
Kristy

"There are two means of refuge from the miseries of life: music and cats." - Albert Schweitzer

[ This Message was edited by: Von Pookie on 2002-04-12 09:04 ]

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 12th, 2002, 09:25 AM	#1
JazzyJen New Member Join Date: Apr 2002 Posts: 23	For the life of me, I can not figure out how to give a currency format to a cell. I have used Format>Cells>Currency, but it is not showing the numbers correctly. I want to be able to type 12550 in a cell and have it appear as 125.50 I do not want to type a decimal, and a dollar symbol would be lovely, but it's not necessary. Any help or suggestions would be appreciated!

Apr 12th, 2002, 09:31 AM	#2
AJ Board Regular Join Date: Mar 2002 Location: =ActiveCell.Address Posts: 478	I reckon the problem is that the Format>Cells>Currency is expecting you to type in dollars, whereas you're actually typing in cents. Why not type in your numbers 12250 in one column (say A) and in the column beside it divide it by 100 to create the decimal point =A1/100 and then format that. Format>Cells>Currency will put it the dollar. Rgds AJ

Apr 12th, 2002, 10:03 AM	#3
Von Pookie MrExcel MVP, Administrator Join Date: Feb 2002 Location: The act or process of locating. Posts: 13,679	Go to Tools/Options/Edit tab. Select Fixed decimals, set it to 2 and click ok to apply changes. Now if you type in 12550 without the decimal, it will show as 125.50, without having to divide it. Hope this helps, _________________ Kristy "There are two means of refuge from the miseries of life: music and cats." - Albert Schweitzer [ This Message was edited by: Von Pookie on 2002-04-12 09:04 ]