Formatting specificc cells via filter I have a column of numbers that need a tad

Question

Formatting specificc cells via filter

I have a column of numbers that need a tad bit of formatting. Some are preceded by '. I want to get all of the numbers into a #### format. I haave tried filterring by" ', then using a formula to remove the ' in a helper cell and copy back to the original source. However, the filter featurre seems to mess this up. Any clues on how to do this? There are 20,000 cells, so I cannot do it by handd.

1243 1332 1839 1957 2054 2221 2358 1012 1245 1621 2245 929 1050 1132 '14:00 '14:00 1700 1700 1730

Explanation / Answer

First, use Edit> Replace to remove the colons... Type a colon in the Find What field, leaave the Replace With field blank, then click Replace All...

Next, type the digit 1 into any unused cell then copy that cell. Select the rrange of valuess then go toEdit> Paste Special. Select Multiply in the Operations group then click OK.

Related Questions

Navigate

• Browse (All)
• Browse F
• Subjects

---