Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old May 11th 09, 07:48 PM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: May 2009
Posts: 3
Default Formatting Lost When Multiple Cells are blank

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 date 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.


  #2   Report Post  
Old May 11th 09, 10:04 PM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: May 2009
Posts: 3
Default Formatting Lost When Multiple Cells are blank

I should clarify. The problem seems to be when there are multiple rows in
which the data for this column is blank.

For example let's say there are seven columns:

First Name, Last Name, Date of Birth, Provider Name, Open Date, End Date, Sex

We have a row for each client, of which there are 55,000 clients and of whom
40,000 of them do not have an End Date. The problem seems to be when there
are many clients in a row without an End Date and then one client with an End
Date.

The cell seems to be formatted correctly when I click on it and go to
FormatCells, but it doesn't seem to display as dictacted in the formatting.
Instead it appears to display as if regular text.

"SIMS Super Support" wrote:

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 date 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.



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Conditional formatting / blank cells torkattack Excel Discussion (Misc queries) 6 March 25th 09 06:44 PM
Conditional Formatting Not Blank Cells Nate Excel Discussion (Misc queries) 6 February 22nd 08 10:25 PM
Lost ability to select multiple cells w/ values & see sum, why? Marianne New Users to Excel 1 October 19th 07 01:00 AM
Linking cells in a Workbook - Formatting is lost Gail Excel Discussion (Misc queries) 4 September 7th 07 04:50 PM
Multiple formatting in text cell blank it out! Tom Excel Discussion (Misc queries) 0 August 1st 06 10:34 AM


All times are GMT +1. The time now is 12:39 PM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017