| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
real number
please help... i need to control if a value in a cell is real number greater then 0. The problem is that excel threads date as a number too...thanx -- kontraa ------------------------------------------------------------------------ kontraa's Profile: http://www.excelforum.com/member.php...o&userid=33028 View this thread: http://www.excelforum.com/showthread...hreadid=528497 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
real number
'RIGHT(TEXT(D21,"dd mmm yyyy"),4) if your date is in d21 this will return the text number 2006, say... you could then apply an IF statement to this -- robert111 ------------------------------------------------------------------------ robert111's Profile: http://www.excelforum.com/member.php...o&userid=31996 View this thread: http://www.excelforum.com/showthread...hreadid=528497 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
real number
On Fri, 31 Mar 2006 05:40:16 -0600, kontraa
wrote: please help... i need to control if a value in a cell is real number greater then 0. The problem is that excel threads date as a number too...thanx Since Excel stores dates as serial numbers, one way of determining if the cell contains a date is to see if the cell is formatted as a date. e.g: =LEFT(CELL("format",A1),1)="D" will be TRUE if the cell is formatted as a date. So maybe something like: =AND(LEFT(CELL("format",A1),1)<"D",COUNTIF(A1,"0 ")) --ron |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
real number
just perfect... thanx a lot... -- kontraa ------------------------------------------------------------------------ kontraa's Profile: http://www.excelforum.com/member.php...o&userid=33028 View this thread: http://www.excelforum.com/showthread...hreadid=528497 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
real number
On Mon, 3 Apr 2006 02:08:26 -0500, kontraa
wrote: just perfect... thanx a lot... Glad to help. --ron |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Seed numbers for random number generation, uniform distribution | Excel Discussion (Misc queries) | |||
| number format | Excel Discussion (Misc queries) | |||
| vlookup with more than number to be retrieved | Excel Worksheet Functions | |||
| Count Number of Characters in a cell? | Excel Discussion (Misc queries) | |||
| Need number of Saturdays and number of Sundays between 2 dates | Excel Worksheet Functions | |||
Hybrid Mode
