How do I insert 2 decimal places to a number in cell?
 

I'm using Excel 2003, and can't figure out how to format an existing number
in a cell. The original number has no decimal, but I'm wanting to insert a
decimal to represent currency (ex: 5308033 = 53080.33)..........help!

One cell or many? Actual value or just presentation.



--
HTH

Bob Phillips

"Rebecca Martinez" <Rebecca wrote in
message ...
I'm using Excel 2003, and can't figure out how to format an existing
number
in a cell. The original number has no decimal, but I'm wanting to insert
a
decimal to represent currency (ex: 5308033 = 53080.33)..........help!

A column of cells.............just presentation.

"Bob Phillips" wrote:

One cell or many? Actual value or just presentation.



--
HTH

Bob Phillips

"Rebecca Martinez" <Rebecca wrote in
message ...
I'm using Excel 2003, and can't figure out how to format an existing
number
in a cell. The original number has no decimal, but I'm wanting to insert
a
decimal to represent currency (ex: 5308033 = 53080.33)..........help!

On Wed, 6 Jul 2005 13:06:02 -0700, "Rebecca Martinez" <Rebecca
wrote:

I'm using Excel 2003, and can't figure out how to format an existing number
in a cell. The original number has no decimal, but I'm wanting to insert a
decimal to represent currency (ex: 5308033 = 53080.33)..........help!

In some cell enter the number 100.

Select that cell and Edit/Copy

Then select your range to be altered and

Paste/Special Operation: Divide





--ron

Try a custom format of

#0\.00

--
HTH

Bob Phillips

"Rebecca Martinez" wrote in
message ...
A column of cells.............just presentation.

"Bob Phillips" wrote:

One cell or many? Actual value or just presentation.



--
HTH

Bob Phillips

"Rebecca Martinez" <Rebecca wrote in
message ...
I'm using Excel 2003, and can't figure out how to format an existing
number
in a cell. The original number has no decimal, but I'm wanting to
insert
a
decimal to represent currency (ex: 5308033 = 53080.33)..........help!

Thanks! It worked!!!

"Ron Rosenfeld" wrote:

On Wed, 6 Jul 2005 13:06:02 -0700, "Rebecca Martinez" <Rebecca
wrote:

I'm using Excel 2003, and can't figure out how to format an existing number
in a cell. The original number has no decimal, but I'm wanting to insert a
decimal to represent currency (ex: 5308033 = 53080.33)..........help!

In some cell enter the number 100.

Select that cell and Edit/Copy

Then select your range to be altered and

Paste/Special Operation: Divide





--ron

On Thu, 7 Jul 2005 06:53:02 -0700, "Rebecca Martinez"
wrote:

Thanks! It worked!!!

You're welcome. Thank you for the feedback

--ron