R rifpool Board Regular Joined May 13, 2006 Messages 71 Oct 19, 2006 #1 How do I.... 732 =7 745 = 7 702 = 7 855 = 8 945 = 9 1020 = 10 I want to drop the last 2 numbers.
Norie Well-known Member Joined Apr 28, 2004 Messages 75,831 Office Version 365 Platform Windows Oct 19, 2006 #2 If you want a formula try this. =LEFT(A1, LEN(A1)-2)
Brian from Maui MrExcel MVP Joined Feb 16, 2002 Messages 8,458 Oct 19, 2006 #4 If you want a formula try this. =LEFT(A1, LEN(A1)-2) Click to expand... For a numeric value, =LEFT(A1, LEN(A1)-2)+0
If you want a formula try this. =LEFT(A1, LEN(A1)-2) Click to expand... For a numeric value, =LEFT(A1, LEN(A1)-2)+0
R rifpool Board Regular Joined May 13, 2006 Messages 71 Oct 19, 2006 #5 ADVERTISEMENT Thanks people. All 3 solutions work just fine, thanks. I'm not sure what exactly is the difference between my ending value coming from a formula or by being numeric?
ADVERTISEMENT Thanks people. All 3 solutions work just fine, thanks. I'm not sure what exactly is the difference between my ending value coming from a formula or by being numeric?
P PaddyD MrExcel MVP Joined May 1, 2002 Messages 14,234 Oct 19, 2006 #6 left(), being a text function, returns a text data item. this is going to choke some of the maths functions (e.g. sum() ). +0 coerces back to a number. in general, better to find a mathematical route to the transformation if you can...
left(), being a text function, returns a text data item. this is going to choke some of the maths functions (e.g. sum() ). +0 coerces back to a number. in general, better to find a mathematical route to the transformation if you can...
Barry Katcher Well-known Member Joined Feb 25, 2002 Messages 4,053 Oct 19, 2006 #7 Yet another possibility:Book1ABCD17327274573702748558594596102010711222112Sheet1
Hi guys, this has me stumped. I am copying data from an online database that I am wanting to add to my own db, I can copy from the info from the...
Hi, Forgive me if I use non-programming terms - I am a self taught coder at a very basic level. And I just learn from forums such as this. But...
Hi Team, I have data in various formate. can I get any formula to find only data. There will be % space on random data but I need only data i.e...
With some of your help I built a spreadsheet that tallies wins in a game, that populates a cell with a win count. Works great. See below...
I have a procedure that pastes in a signature from another sheet, just below the bottom of a quote. Is there a way to push it to the next page if...
Hi, I have a formula that works until the times involved span 2 days: Formula is "=TEXT((EE24-DT24)-(FA24-EP24)-(FW24-FL24),"h:mm")" it first...