 philfnaPremium join:2003-12-30 Wisconsin | reply to pog
Re: Another excel question I was actually for the number not just the formatting...thanks for trying  |
|
 | Did my solution work? |
|
 efrem join:2002-04-03 Westport, CT | reply to philfna
said by philfna:I was actually for the number not just the formatting...thanks for trying :-) If I understand your request (and that's a real if), how about this:
So if you have 0.75 in Cell A1 and that formula in Cell B1, then Cell B1 will display 1 / 1.33 .
Does that give you both the number AND the format you want? |
|
|
|