| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Format cell?
How do I format a cell to read the following.
56033 or 56034/34 I input the data above on cell"A1" and on cell "F1" I have the following formula =A1 It works with the first number but not with the second one. Any ideas? -- Sophie |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Format cell?
Hi Sophie
You say its not working, what is it doing? what are you getting in that cell? John "Sophie" wrote in message ... How do I format a cell to read the following. 56033 or 56034/34 I input the data above on cell"A1" and on cell "F1" I have the following formula =A1 It works with the first number but not with the second one. Any ideas? -- Sophie |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Format cell?
In cell "A1" has the following formular
=LOOKUP(2,1/(detail!D4:D4997),detail!D4:D4997) which looks up the column and picks the last entry. But if the number has a forward slash it picks the next number with no slash. Cell "F1" displays what is in cell "A1". -- Sophie "John" wrote: Hi Sophie You say its not working, what is it doing? what are you getting in that cell? John "Sophie" wrote in message ... How do I format a cell to read the following. 56033 or 56034/34 I input the data above on cell"A1" and on cell "F1" I have the following formula =A1 It works with the first number but not with the second one. Any ideas? -- Sophie |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Format cell?
Actually, that formula picks up the last numeric (non-zero) entry.
If you want the last non-empty entry: =LOOKUP(2,1/(detail!D4:D4997<""),detail!D4:D4997) Sophie wrote: In cell "A1" has the following formular =LOOKUP(2,1/(detail!D4:D4997),detail!D4:D4997) which looks up the column and picks the last entry. But if the number has a forward slash it picks the next number with no slash. Cell "F1" displays what is in cell "A1". -- Sophie "John" wrote: Hi Sophie You say its not working, what is it doing? what are you getting in that cell? John "Sophie" wrote in message ... How do I format a cell to read the following. 56033 or 56034/34 I input the data above on cell"A1" and on cell "F1" I have the following formula =A1 It works with the first number but not with the second one. Any ideas? -- Sophie -- Dave Peterson |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Format cell?
Thank you very much, just the job it works well.
-- Sophie "Dave Peterson" wrote: Actually, that formula picks up the last numeric (non-zero) entry. If you want the last non-empty entry: =LOOKUP(2,1/(detail!D4:D4997<""),detail!D4:D4997) Sophie wrote: In cell "A1" has the following formular =LOOKUP(2,1/(detail!D4:D4997),detail!D4:D4997) which looks up the column and picks the last entry. But if the number has a forward slash it picks the next number with no slash. Cell "F1" displays what is in cell "A1". -- Sophie "John" wrote: Hi Sophie You say its not working, what is it doing? what are you getting in that cell? John "Sophie" wrote in message ... How do I format a cell to read the following. 56033 or 56034/34 I input the data above on cell"A1" and on cell "F1" I have the following formula =A1 It works with the first number but not with the second one. Any ideas? -- Sophie -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Lock Cell Format - Allow copy and paste of data without format change | Excel Worksheet Functions | |||
| Can cell format come from and change with reference cell format | Excel Discussion (Misc queries) | |||
| how do i format a cell based on format of a range of cells? | Excel Discussion (Misc queries) | |||
| How do I copy data in single cell format to a merged cell format | Excel Discussion (Misc queries) | |||
Linear Mode
