Thread
:
How do I insert 2 decimal places to a number in cell?
View Single Post
#
5
Ron Rosenfeld
Posts: n/a
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
Reply With Quote