Custome number format help

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

WB - 21 Jul 2006 20:48 GMT

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

Reply to this Message

Carmen - 21 Jul 2006 21:07 GMT

WB, I put

#,k

in the custom formatting box and it looks like it worked

Signature

CARMEN HOVENDICK

>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
[quoted text clipped - 6 lines]
>
> WB

Reply to this Message

WB - 21 Jul 2006 21:03 GMT

Thanks, yes it did.

> WB, I put
>
[quoted text clipped - 12 lines]
> >
> > WB

Reply to this Message