| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Standard index form - Generating leading number (before *10^x part
"Neil Goldwasser" ha scritto nel
messaggio ... Hi all! Here is a challenge for you... Does anybody know how to combine worksheet functions to generate the leading number from the Standard Index Form version of a "normal number"? For example,... ...if the input was 340000, the output would be 3.4 ...if the input was 0.00278, the output would be 2.78 your number in [A1] in [B1] =A1/10^INT(LOG(A1)) or =TEXT(A1/10^(INT(LOG(A1))),"0.00") & "E" &TEXT(INT(LOG(A1)),"000") .f |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Standard index form - Generating leading number (before *10^x
Thanks everyone! Problem solved... and much appreciated!
Neil Goldwasser "fernando cinquegrani" wrote: "Neil Goldwasser" ha scritto nel messaggio ... Hi all! Here is a challenge for you... Does anybody know how to combine worksheet functions to generate the leading number from the Standard Index Form version of a "normal number"? For example,... ...if the input was 340000, the output would be 3.4 ...if the input was 0.00278, the output would be 2.78 your number in [A1] in [B1] =A1/10^INT(LOG(A1)) or =TEXT(A1/10^(INT(LOG(A1))),"0.00") & "E" &TEXT(INT(LOG(A1)),"000") .f |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Standard index form - Generating leading number (before *10^x
PS - The "winner" was.....
your number in [A1] in [B1] =A1/10^INT(LOG(A1)) This was the only one that took account of ALL decimal places needed, as well as taking account of zeros sandwiched between non-zero digits and therefore still needed (i.e. zeros that are NOT at the end of the number). For example, the leading number for 10203000 should be 1.0203, and this was the only formula to produce this. Again, many thanks for all your help! Neil Goldwasser "Neil Goldwasser" wrote: Thanks everyone! Problem solved... and much appreciated! Neil Goldwasser "fernando cinquegrani" wrote: "Neil Goldwasser" ha scritto nel messaggio ... Hi all! Here is a challenge for you... Does anybody know how to combine worksheet functions to generate the leading number from the Standard Index Form version of a "normal number"? For example,... ...if the input was 340000, the output would be 3.4 ...if the input was 0.00278, the output would be 2.78 your number in [A1] in [B1] =A1/10^INT(LOG(A1)) or =TEXT(A1/10^(INT(LOG(A1))),"0.00") & "E" &TEXT(INT(LOG(A1)),"000") .f |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Standard index form - Generating leading number (before *10^x
Fair enough. You're right.
"Neil Goldwasser" wrote in message ... PS - The "winner" was..... your number in [A1] in [B1] =A1/10^INT(LOG(A1)) This was the only one that took account of ALL decimal places needed, as well as taking account of zeros sandwiched between non-zero digits and therefore still needed (i.e. zeros that are NOT at the end of the number). For example, the leading number for 10203000 should be 1.0203, and this was the only formula to produce this. Again, many thanks for all your help! Neil Goldwasser "Neil Goldwasser" wrote: Thanks everyone! Problem solved... and much appreciated! Neil Goldwasser "fernando cinquegrani" wrote: "Neil Goldwasser" ha scritto nel messaggio ... Hi all! Here is a challenge for you... Does anybody know how to combine worksheet functions to generate the leading number from the Standard Index Form version of a "normal number"? For example,... ...if the input was 340000, the output would be 3.4 ...if the input was 0.00278, the output would be 2.78 your number in [A1] in [B1] =A1/10^INT(LOG(A1)) or =TEXT(A1/10^(INT(LOG(A1))),"0.00") & "E" &TEXT(INT(LOG(A1)),"000") .f |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Standard index form - Generating leading number (before *10^x
Many thanks for your help though, I really appreciate it!
Neil "Castell" wrote: Fair enough. You're right. "Neil Goldwasser" wrote in message ... PS - The "winner" was..... your number in [A1] in [B1] =A1/10^INT(LOG(A1)) This was the only one that took account of ALL decimal places needed, as well as taking account of zeros sandwiched between non-zero digits and therefore still needed (i.e. zeros that are NOT at the end of the number). For example, the leading number for 10203000 should be 1.0203, and this was the only formula to produce this. Again, many thanks for all your help! Neil Goldwasser "Neil Goldwasser" wrote: Thanks everyone! Problem solved... and much appreciated! Neil Goldwasser "fernando cinquegrani" wrote: "Neil Goldwasser" ha scritto nel messaggio ... Hi all! Here is a challenge for you... Does anybody know how to combine worksheet functions to generate the leading number from the Standard Index Form version of a "normal number"? For example,... ...if the input was 340000, the output would be 3.4 ...if the input was 0.00278, the output would be 2.78 your number in [A1] in [B1] =A1/10^INT(LOG(A1)) or =TEXT(A1/10^(INT(LOG(A1))),"0.00") & "E" &TEXT(INT(LOG(A1)),"000") .f |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Three new functions that should be part of your standard set | Excel Worksheet Functions | |||
| Can a standard data entry form be used to change formats of cells? | Excel Discussion (Misc queries) | |||
| Replace/modify standard data form? | Excel Discussion (Misc queries) | |||
| standard form | Excel Discussion (Misc queries) | |||
| How do I set up a standard form showing incentive calculations | Excel Discussion (Misc queries) | |||
Hybrid Mode
