data formatting integrity

  • Thread starter Thread starter kim.miller2
  • Start date Start date
K

kim.miller2

I have a VBA Macro that takes data from one spreadsheet to another. In
the new sheet there is a little formatting and some sorting. When the
Macro ends it seems as though the program stops on a specific cell. In
thetask Bar it shows this: Sum = 38565. What should really be in the
Cell is Aug-05 as a date. I've tried formatting the from Cell to
"General" and to "Date", but these don't seem to work. Can anyone help?
 
it sounds like this cell is actually text even if it looks like a number.
try multiplying the cell by one or adding 0. this may solve your problem.
 

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

Remove date format? 3
How to Keep Excel Sheet Formatting On a CSV Sheet with vba 1
Cell Format 1
Date Calculation & Conditional Formatting 3
Cell not calculating after importing data 2
Conditional formatting in Excel 2010 2
Excel Import Comments 3
Formatting dates after importing data 4

Back
Top