Get instant live expert help on I need help with random 3 digit number
“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”
Here are some problems that our users have asked and received explanations on
Excel keeps changing my 10 digit number that I enter and adds a decimal points followed by random numbers.
Solved by S. Q. in 17 mins
I am consolidating a spreadsheet of 5 digit zip codes to 3 digit zip codes. I need formulas to match the information from the 5 digit zip code sheet to a smaller 3 digit zip code table.
Solved by M. S. in 18 mins
I need a formula that will translate numbers from a range into a single digit. Ex. any number between 37-52 needs to show "3"
Solved by K. U. in 16 mins
Hi, I have a column which is a text number column. That has few 4 digit values and there are few 5 digit values. I have a complete sheet of 80000 records. So is there any formula that can separate the four digit numbers and the five digit numbers
Solved by M. H. in 26 mins
I need help with format cell. only issue I have is that sometime the digit is 3 digit instead of 4. I can figure out how to convert the coding so that if I enter 1519909, it will be 015-19-909. But if the last digit needs 4 digit like 356197984, it will be 356-19-7984.
Solved by D. Y. in 21 mins