Formatting Numbers
A while back I was asked how to make all phone numbers in a list the same format. I don't have a very good solution, but I have something. The first idea I had was to do data validation in the Google Form where you collect the data. Getting data as pure as you can when you collect it is always the best. But the information had already been collected. The first thing I wanted to do was to see if I could get a list of random numbers. Fortunately, Google Sheets has a RAND function that will do just that. Step 2 was to copy the numbers without formatting. When you paste into Google Sheets, there is a little clipboard icon that shows up. Clicking that will give you the option for a menu where you can choose to paste the values or the formatting. I chose the values because I didn't want the function anymore. Besides being good practice, the RAND function would have kept changing the data. The next thing I did was to reformat the numbers. I went to format > number > custom numbe