Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
command?
I am fairly new at using Excel, and am having a problem finding a
command, if there is one, to just select the last two digits of a number and use it in a formula then paste in back on the end of the original number. I am using Excel 2000. example: 422733 take the last two digits and divide them by 60 and end up with a final number 4227.55 Thanks, Don |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
command?
Hi Don
422733\100 + (422733 mod 100)/60 -- HTH RP (remove nothere from the email address if mailing direct) "Don B" wrote in message ... I am fairly new at using Excel, and am having a problem finding a command, if there is one, to just select the last two digits of a number and use it in a formula then paste in back on the end of the original number. I am using Excel 2000. example: 422733 take the last two digits and divide them by 60 and end up with a final number 4227.55 Thanks, Don |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
command?
Hi Don,
There must be smarter ways, but here's one: =INT(A1/100)+(A1-(INT(A1/100)*100))/60 -- Kind Regards, Niek Otten Microsoft MVP - Excel "Don B" wrote in message ... I am fairly new at using Excel, and am having a problem finding a command, if there is one, to just select the last two digits of a number and use it in a formula then paste in back on the end of the original number. I am using Excel 2000. example: 422733 take the last two digits and divide them by 60 and end up with a final number 4227.55 Thanks, Don |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
One command in one cell initiating another command in another cel. | Excel Worksheet Functions | |||
command code ( GOTO command) in formula | New Users to Excel | |||
command button add another command | Excel Discussion (Misc queries) | |||
Pivot Table Error Message - "Command Text not set for command obje | Excel Discussion (Misc queries) | |||
Excel has a "Find Next" command but no "Find Previous" command. | Excel Discussion (Misc queries) |