Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Formula
My first field is G2
205,801 I'm trying to get it read: 205 Is this formula correct: =LEFT(G2,SEARCH(",",G2)-1) It did not work. Thanks again. DaveB Subject: Formula From: "Dan E" Sent: 10/22/2003 9:16:26 AM =LEFT(A1,SEARCH(",",A1)-1) Dan E "DaveB" wrote in message ... I am trying to delete all numbers to right of ",". Can you share the code. Thanks in advance. From: 201,076 15,006 6,985 To: 201 15 7 DaveB |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Formula
Dave
It's a number so the comma is only shown in the displayed value. The cell actually contains 205801 Try: =VALUE(LEFT(A1,3)) That works for this value with six digits but if you need something more general you could try this: =VALUE(LEFT(TEXT(G2,"000,000"),SEARCH(",",TEXT(G2, "000,000"))-1)) Regards Trevor "DaveB" wrote in message ... My first field is G2 205,801 I'm trying to get it read: 205 Is this formula correct: =LEFT(G2,SEARCH(",",G2)-1) It did not work. Thanks again. DaveB Subject: Formula From: "Dan E" Sent: 10/22/2003 9:16:26 AM =LEFT(A1,SEARCH(",",A1)-1) Dan E "DaveB" wrote in message ... I am trying to delete all numbers to right of ",". Can you share the code. Thanks in advance. From: 201,076 15,006 6,985 To: 201 15 7 DaveB |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Commenting custom formula fields/formula on formula editor | Excel Programming |