formatting in thousands

I figure there must be an easy way to do this. I would like 1,000 to
display as 1, or 17,000 to display as 17.
My boss says just divide by 1,000!!

--

Have the bestest day ever!!
patti

Tools>Options>Edit, set the Fixed Decimal Places checkbox, and set the
places to 3.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"patti" <[email protected]> wrote in message
news:eRFs%[email protected]...
> I figure there must be an easy way to do this. I would like 1,000 to
> display as 1, or 17,000 to display as 17.
> My boss says just divide by 1,000!!
>
> --
>
> Have the bestest day ever!!
> patti
>
>
>

select dat aand do Format / Cells - Pick any numeric format, then hit custom
and put a comma at
the end of each segment, eg if you just used number format then you would
have

0.00 so add comma to get
0.00,

or from 0 to 0,

Accounting format as another example

_-£* #,##0.00_-;-£* #,##0.00_-;_-£* "-"??_-;_-@_- to
_-£* #,##0.00,_-;-£* #,##0.00,_-;_-£* "-"??_-;_-@_-

Each comma will reduce by factor of 1000, so 2 commas give you millions etc

eg 0,,

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------

thanx this just what I wanted!!

--

Have the bestest day ever!!
patti


"Ken Wright" <[email protected]> wrote in message
news:[email protected]...
> select dat aand do Format / Cells - Pick any numeric format, then hit
> custom
> and put a comma at
> the end of each segment, eg if you just used number format then you would
> have
>
> 0.00 so add comma to get
> 0.00,
>
> or from 0 to 0,
>
> Accounting format as another example
>
> _-£* #,##0.00_-;-£* #,##0.00_-;_-£* "-"??_-;_-@_- to
> _-£* #,##0.00,_-;-£* #,##0.00,_-;_-£* "-"??_-;_-@_-
>
> Each comma will reduce by factor of 1000, so 2 commas give you millions
> etc
>
> eg 0,,
>
> --
> Regards
> Ken....................... Microsoft MVP - Excel
> Sys Spec - Win XP Pro / XL 97/00/02/03
>
> ----------------------------------------------------------------------------
> It's easier to beg forgiveness than ask permission :-)
> ----------------------------------------------------------------------------
>
>

i think this is for thousandths, I wanted thousands

thanx

--

Have the bestest day ever!!
patti


"Bob Phillips" <[email protected]> wrote in message
news:[email protected]...
> Tools>Options>Edit, set the Fixed Decimal Places checkbox, and set the
> places to 3.
>
> --
>
> HTH
>
> RP
> (remove nothere from the email address if mailing direct)
>
>
> "patti" <[email protected]> wrote in message
> news:eRFs%[email protected]...
>> I figure there must be an easy way to do this. I would like 1,000 to
>> display as 1, or 17,000 to display as 17.
>> My boss says just divide by 1,000!!
>>
>> --
>>
>> Have the bestest day ever!!
>> patti
>>
>>
>>
>
>

It displays 1000 as 1 for me, 17000 as a 17

--

HTH

RP
(remove nothere from the email address if mailing direct)


"patti" <[email protected]> wrote in message
news:[email protected]...
> i think this is for thousandths, I wanted thousands
>
> thanx
>
> --
>
> Have the bestest day ever!!
> patti
>
>
> "Bob Phillips" <[email protected]> wrote in message
> news:[email protected]...
> > Tools>Options>Edit, set the Fixed Decimal Places checkbox, and set the
> > places to 3.
> >
> > --
> >
> > HTH
> >
> > RP
> > (remove nothere from the email address if mailing direct)
> >
> >
> > "patti" <[email protected]> wrote in message
> > news:eRFs%[email protected]...
> >> I figure there must be an easy way to do this. I would like 1,000 to
> >> display as 1, or 17,000 to display as 17.
> >> My boss says just divide by 1,000!!
> >>
> >> --
> >>
> >> Have the bestest day ever!!
> >> patti
> >>
> >>
> >>
> >
> >
>
>