Formula Audit Toolbar

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.???
 
If your dates are in one column, maybe you could use data|text to columns.

Tell excel that its a date (mdy, ydm, whatever matches) and excel may be able to
figure it out.

If you have 12/31/04 in a cell (mdy) and that matches your regional
settings--maybe you could just:
Edit|Replace
what: /
with: /
replace all.

You may want to post more about what your data looks like if this didn't help.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Automatically convert Text with 2-digit year 2
Formula Audit mode active in one column only; cannot kill. 2
formula auditing toolbar items disabled 1
Importing a large text file 4
dragging formula works for columns but not rows? 2
How do I activate the formula auditing toolbar 3
2 digit year in dates return 19xx not 20xx 1
What would cause the formula auditing toolbar to be grayed out? 4

Back
Top