Thursday, January 27, 2005

Trick custom formats in Excel

As a follow up to the entry about custom formats here's a formatting trick Mark discovered a few years ago.

Format a cell with a custom format of \bill,
Now enter any number in this cell. Positive numbers or results of formulas will return bill while negative numbers will give you -bill.

Try other variations using the \ in the front. I am not sure why or how this works or what the logic is for some text giving different results. For example \gra will work but \grant won't. \time returns ti11900.
If anybody knows why this is so please let me know! Add a comment so everybody else can find out too.

Don't forget you can be added to the email list if you want. The subscribe to the daily email link is in the side bar.