| Forum Home | ||||
| Press F1 | ||||
| Thread ID: 27228 | 2002-11-17 18:21:00 | Start with a zero | veterannz (960) | Press F1 |
| Post ID | Timestamp | Content | User | ||
| 99230 | 2002-11-17 18:21:00 | How do I put a number in an Excel cell that starts with three zeros. I cant use an apostrophe before the number because excel recognizes the number as text . I already have 19000 other numbers starting with the 3 zeros and have to be able to sort the columns by numerical order | veterannz (960) | ||
| 99231 | 2002-11-17 19:41:00 | You can make it appear to have three leading zeroes by setting a custom format like 000000 (will allow a six digit number, including three leading zeroes) or 00000000 (or whatever). This would allow you to use the numbers in formulae, but only works if they are consistent is the number of digits. robo |
robo (205) | ||
| 99232 | 2002-11-18 21:07:00 | Seems to me that if you want literally three zeros every time before a no-zero digit you use a custom format like 000###.00 (if you want two decimal places, or etc.). The 000000 suggestion seems to me to produce say 000123 and 000023 etc. for 123 and and 23, whereas what is asked for seems to be 000123 and 00023, which my suggestion above will produce. Is this right? What actually was wanted? |
rugila (214) | ||
| 99233 | 2002-11-18 21:23:00 | Use a custom format of: \0\0\0# |
wuppo (41) | ||
| 1 | |||||