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!
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 [email protected]> wrote in
message news:[email protected]...
> 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 [email protected]> wrote in
> message news:[email protected]...
> > 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
[email protected]> 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" <[email protected]> wrote in
message news:[email protected]...
> A column of cells.............just presentation.
>
> "Bob Phillips" wrote:
>
> > One cell or many? Actual value or just presentation.
> >
> >
> >
> > --
> > HTH
> >
> > Bob Phillips
> >
> > "Rebecca Martinez" <Rebecca [email protected]> wrote in
> > message news:[email protected]...
> > > 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
> [email protected]> 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"
<[email protected]> wrote:
>Thanks! It worked!!!
You're welcome. Thank you for the feedback
--ron
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks