Currency Formatting Problem

JazzyJen

New Member
Joined
Apr 11, 2002
Messages
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!
 

Excel Facts

Control Word Wrap
Press Alt+Enter to move to a new row in a cell. Lets you control where the words wrap.
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
 
Upvote 0
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
 
Upvote 0

Forum statistics

Threads
1,213,489
Messages
6,113,952
Members
448,535
Latest member
alrossman

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top