Date Formatting Lost when multiple cells are blank

S

SIMS Super Support

I provide technical support for software users. These users export data from
the software with multiple columns and multiple rows. One column for End
Date is formatted as Custom format Type: m/d/yyy" "h\:mm\:ss AM/PM.

These files are often very large, sometimes over 55,000 rows. The problem
happens when there are multiple rows in a row without data. It seems as if
the formatting is lost.

For example, the first ten rows have data recorded (date and time) and there
are then 500 rows with blank data and then the next ten rows (rows 511
through 521) have data. These cells don't seem to retain the proper
formatting. They show the data but not the time.

I'm sorry if I can't explain this well. Has anyone ever seen anything like
this? I'm not even sure how to search for similar posts on this issue.

Any help would be appreciated.
 

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

Formatting Lost When Multiple Cells are blank 1
Delete Blank Excel Rows 2
Apply cell formatting using VBA 1
How to hide rows, but not blank rows used for formatting 10
Comparison of columns using Conditional Formatting 3
Graphing Question: Blank Lines Problem ? 2
Apply conditional formatting to non-blank cells 2
If specific cell is not empty, copy (or enter) formulas and format 2

Top