Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
easy function quesiton
=a1
this is returning a value of 0 until the the data is typed how can i make this go away Please advise |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
easy function quesiton
Like this:
=IF(A1="","",A1) -- Biff Microsoft Excel MVP "Dylan @ UAFC" wrote in message ... =a1 this is returning a value of 0 until the the data is typed how can i make this go away Please advise |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
easy function quesiton
use custom format as 0;0;;@
OR Go to tools | options | view tab | uncheck zero values | ok | On Jan 21, 12:09*am, Dylan @ UAFC wrote: =a1 this is returning a value of 0 until the the data is typed how can i make this go away Please advise |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
quesiton on links | Excel Discussion (Misc queries) | |||
Pivot Table Quesiton | Excel Worksheet Functions | |||
Easy IF Function | Excel Discussion (Misc queries) | |||
Sum function question - easy? | Excel Worksheet Functions | |||
If..then quesiton. | Excel Worksheet Functions |