I have a series of cells that will hold values such as 350,000.00. This
value is entered by the user and entire amount is used in calculations
across the worksheet.

I want the output to be 350k. This way, more columns can be viewed at a
time and makes for easier reading than a number with all the zeros.

I can't get the customer number format to "hide" the zeros.

WB

Thanks, yes it did.
"Carmen" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> WB, I put
>
> #,k
>
> in the custom formatting box and it looks like it worked
>
> --
> CARMEN HOVENDICK
>
> "WB" <none> wrote in message
news:O%(E-Mail Removed)...
> >I have a series of cells that will hold values such as 350,000.00. This
> > value is entered by the user and entire amount is used in calculations
> > across the worksheet.
> >
> > I want the output to be 350k. This way, more columns can be viewed at a
> > time and makes for easier reading than a number with all the zeros.
> >
> > I can't get the customer number format to "hide" the zeros.
> >
> > WB
> >
> >
>
>

WB, I put

#,k

in the custom formatting box and it looks like it worked

--
CARMEN HOVENDICK

"WB" <none> wrote in message news:O%(E-Mail Removed)...
>I have a series of cells that will hold values such as 350,000.00. This
> value is entered by the user and entire amount is used in calculations
> across the worksheet.
>
> I want the output to be 350k. This way, more columns can be viewed at a
> time and makes for easier reading than a number with all the zeros.
>
> I can't get the customer number format to "hide" the zeros.
>
> WB
>
>