Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Formula Audit Toolbar
I have imported some huge data files, and Excel is reading the numbers and
dates as text. I can click on the Formula Audit Toolbar, and it will scroll through each cell - all 64,000 of them!, giving me the options. Is there a way to just blanket the column and say, yes, convert XX to 20XX, and in the next column, yes, convert text to number, etc.??? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Creating Formula using check boxes | Excel Discussion (Misc queries) | |||
I want the results of a formula to show in cell, NOT THE FORMULA! | Excel Discussion (Misc queries) | |||
Paste is is copying in formula, but display is wrong. | Excel Discussion (Misc queries) | |||
Excel2K: Is it possible to use dynamic named ranges in custom data validation formula? | Excel Discussion (Misc queries) | |||
How do I stop the Reviewing toolbar from showing up in Excel? | Excel Discussion (Misc queries) |