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 :-)
> ----------------------------------------------------------------------------
>
>