Currency Formatting question

[Tom Petersen]

Is there a way to format a cell in such a way that if the user types in
something like 111 it will format to $1.11? I tried playing with the
decimal points in the properties but I couldn't figure it out. basically, I
need the decimal point to be inserted before the last two numbers.

123345 would be $1233.45, 45 would be $.45, etc...

TIA!

 

[Chris Chandler]

Is there a way to format a cell in such a way that if the user types in
something like 111 it will format to $1.11? I tried playing with the
decimal points in the properties but I couldn't figure it out.
basically, I need the decimal point to be inserted before the last two
numbers.

123345 would be $1233.45, 45 would be $.45, etc...

TIA!

Setup the formatting in the cell to Currency

 

[Tom Petersen]

I tried that, but I still have to hit the decimal point, I want to know if
it can be automatic.

 

[Peo Sjoblom]

Format as currency and do tools>options>edit and check fixed decimal
places,
select 2 from scroll down


--

Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)

 

[Tom Petersen]

Thanks!

That is what I wanted...

Format as currency and do tools>options>edit and check fixed decimal
places,
select 2 from scroll down


--

Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)

 

[Peo Sjoblom]

Just remember to turn it off when you are done or it will behave this way
for other workbooks as well
if you want an integer enter it as 123.
(end with a period) that will give you 123 and not 1.23

--

Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)

 

[Dave Peterson]

Another option maybe to adjust your currency format so that you could just hit
that $ icon.

Format|Style
Select Currency from the dropdown.
Then click Modify, then change the number format to something like:

_(#.00_);_((#.00);_("-"??_);_(@_)

(or whatever you really want.)

This style is a workbook level change--it won't affect any other workbooks
(well, unless you use this workbook for a "template".)