| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hide font in formula
Hi all, Small problem. Have a formula in a cell =a1*g1. Problem is I dont wan the value when selected to show. I would accept the cell showing "Inc or even changing colour but the value cannot show as it is a price. Can anyone please help?? Cheers!! -- gavme ----------------------------------------------------------------------- gavmer's Profile: http://www.excelforum.com/member.php...nfo&userid=666 View this thread: http://www.excelforum.com/showthread.php?threadid=26224 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Hide font in formula
format = cells = Number Tab, select custom
use ;;; for the format. -- Regards, Tom Ogilvy "gavmer" wrote in message ... Hi all, Small problem. Have a formula in a cell =a1*g1. Problem is I dont want the value when selected to show. I would accept the cell showing "Inc" or even changing colour but the value cannot show as it is a price. Can anyone please help?? Cheers!!! -- gavmer ------------------------------------------------------------------------ gavmer's Profile: http://www.excelforum.com/member.php...fo&userid=6662 View this thread: http://www.excelforum.com/showthread...hreadid=262249 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Specify a font from a formula? | Excel Worksheet Functions | |||
| If Cell is Blank (Though a Link), Hide Result, Else Normal Font | Excel Worksheet Functions | |||
| Protect individual cell and hide formula in formula bar | Excel Worksheet Functions | |||
| Font in Formula Bar | Excel Discussion (Misc queries) | |||
| Excel - Hide Column/s or Change Font color Only for printing | Excel Discussion (Misc queries) | |||
![gavmer[_76_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
