Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Value type
How do I write a formula that can tell if a cell is a date or a value so it can display the correct info - I hava 3 columns - one is text - one is currency - one is date. I have a cell that can pick between all 3 ( say A1 or B1 or C1 ) but it shows the currency and date as a date style cell if its looking at the currency value??? -- sparx ------------------------------------------------------------------------ sparx's Profile: http://www.excelforum.com/member.php...o&userid=16787 View this thread: http://www.excelforum.com/showthread...hreadid=488775 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Value type
The IS command does not perform the function needed as there must be another way of working it out. -- sparx ------------------------------------------------------------------------ sparx's Profile: http://www.excelforum.com/member.php...o&userid=16787 View this thread: http://www.excelforum.com/showthread...hreadid=488775 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Value type
There is no way to tell if the cell value is a date (at least not full
proof) an excel date is a number so you can test for ISNUMBER and ISTEXT thus the IS functions are the way to go =IF(ISNUMBER(A1),"do this","do that") -- Regards, Peo Sjoblom "sparx" wrote in message ... The IS command does not perform the function needed as there must be another way of working it out. -- sparx ------------------------------------------------------------------------ sparx's Profile: http://www.excelforum.com/member.php...o&userid=16787 View this thread: http://www.excelforum.com/showthread...hreadid=488775 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Value type
put this into a regular modulethen =if(isadate(g4),1,2)
Function isadate(x) If isdate(x) Then isadate = True End Function -- Don Guillett SalesAid Software "sparx" wrote in message ... The IS command does not perform the function needed as there must be another way of working it out. -- sparx ------------------------------------------------------------------------ sparx's Profile: http://www.excelforum.com/member.php...o&userid=16787 View this thread: http://www.excelforum.com/showthread...hreadid=488775 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Value type
Please provide a couple of lines of sample data, the formula you use to do
the "picking" between the three columns, and the desired results............... Vaya con Dios, Chuck, CABGx3 "sparx" wrote: How do I write a formula that can tell if a cell is a date or a value so it can display the correct info - I hava 3 columns - one is text - one is currency - one is date. I have a cell that can pick between all 3 ( say A1 or B1 or C1 ) but it shows the currency and date as a date style cell if its looking at the currency value??? -- sparx ------------------------------------------------------------------------ sparx's Profile: http://www.excelforum.com/member.php...o&userid=16787 View this thread: http://www.excelforum.com/showthread...hreadid=488775 |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Value type
Maybe you could use something like:
sparx wrote: How do I write a formula that can tell if a cell is a date or a value so it can display the correct info - I hava 3 columns - one is text - one is currency - one is date. I have a cell that can pick between all 3 ( say A1 or B1 or C1 ) but it shows the currency and date as a date style cell if its looking at the currency value??? -- sparx ------------------------------------------------------------------------ sparx's Profile: http://www.excelforum.com/member.php...o&userid=16787 View this thread: http://www.excelforum.com/showthread...hreadid=488775 -- Dave Peterson |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
Value type
....something like...
=IF(AND(ISNUMBER(A1),LEFT(CELL("format",A1),1)="d" ),"it's a date","not a date") sparx wrote: How do I write a formula that can tell if a cell is a date or a value so it can display the correct info - I hava 3 columns - one is text - one is currency - one is date. I have a cell that can pick between all 3 ( say A1 or B1 or C1 ) but it shows the currency and date as a date style cell if its looking at the currency value??? -- sparx ------------------------------------------------------------------------ sparx's Profile: http://www.excelforum.com/member.php...o&userid=16787 View this thread: http://www.excelforum.com/showthread...hreadid=488775 -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Select rows and sort based on type | Excel Discussion (Misc queries) | |||
date type format which is supported by excel 2003 | Charts and Charting in Excel | |||
vlookup argument type | Excel Worksheet Functions | |||
multiple results display after filter function | Excel Worksheet Functions | |||
How do I type 24 square metres using arithmetical notation | Excel Discussion (Misc queries) |