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" <pminotti@msn.com> wrote in message
news:eRFs%23oXIFHA.580@TK2MSFTNGP15.phx.gbl...
> 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
>
>
>

i think this is for thousandths, I wanted thousands

thanx

--

Have the bestest day ever!!
patti


"Bob Phillips" <bob.phillips@notheretiscali.co.uk> wrote in message
news:uw$wevXIFHA.2736@TK2MSFTNGP09.phx.gbl...
> 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" <pminotti@msn.com> wrote in message
> news:eRFs%23oXIFHA.580@TK2MSFTNGP15.phx.gbl...
>> 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" <pminotti@msn.com> wrote in message
news:OAVepqZIFHA.3664@TK2MSFTNGP10.phx.gbl...
> i think this is for thousandths, I wanted thousands
>
> thanx
>
> --
>
> Have the bestest day ever!!
> patti
>
>
> "Bob Phillips" <bob.phillips@notheretiscali.co.uk> wrote in message
> news:uw$wevXIFHA.2736@TK2MSFTNGP09.phx.gbl...
> > 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" <pminotti@msn.com> wrote in message
> > news:eRFs%23oXIFHA.580@TK2MSFTNGP15.phx.gbl...
> >> 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" <ken.wright@NOSPAMntlworld.com> wrote in message
news:uc7Ye0XIFHA.276@tk2msftngp13.phx.gbl...
> 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 :-)
> ----------------------------------------------------------------------------
>
>