Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Looking to break a large number down
Hello DLW,
That works for my numbers, UNLESS the first number is a 0 (ie. 098 returns as 9 | 8 | 8. It's possible that I have to make it a text.. but when I tried it still drops off the beginning 0. :( Does anyone have any other suggestions or incorporate the =LEFT / MID / RIGHT Thank You. David "dlw" wrote: =left(k1,1) =mid(k1,2,1) =right(k1,1) "David" wrote: Sorry, I would search the topics but I am unsure even what to look for. I have a column of number that are three digits in size. They could range from 001 through 999. I would like to split it up so each digit is in it's own column. So if ColumnK had the number 459 in it then I would like ColumnM to show the number 4, ColumnN to show the number 5 and ColumnO to show the number 9. Same with if the number is 99 (ColumnK would show 099, and I would want the number 0 to show in ColumnM). Thank You Everyone who knows how to do this. :) David |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Looking to break a large number down | Excel Discussion (Misc queries) | |||
How to break apart a Decimal formatted number? | Excel Discussion (Misc queries) | |||
How do I break a large .CSV file into several small Excel files? | Excel Worksheet Functions | |||
How do I show break in bar graph to show large and small numbers | Charts and Charting in Excel | |||
How do I show break in bar graph to show large and small numbers | Charts and Charting in Excel |