Inserting Rows...but losing "FORMAT"
in [General]
|
Prev: How to prevent Cut&Paste to change style and data validation on protected sheet
Next: Any way to get Freeze Panes to work with Split View?
From: FLKULCHAR on 22 Mar 2010 10:01 I have a spreadsheet that I have used for 5 years...with daily data being inputted (in newly inserted rows), then Grand Totaled at the bottom of the spreadsheet. I have never had a problem...UNTIL RECENTLY. One of my columns is the time of day, such as 2:54pm, and presently, all of my inserted rows, except for only 3 of them, depict the time as 2:54 (WITHOUT THE AM or PM), so, I use the Format Painter, and I Fix the problem...that is, until the next day, when the same incident again occurs. I do not know why this is happening, but I must use this extra step (Format Painter) to 'fix' the dilemma. Can anyone advise me as to how I can avoid this awkward situation...bearing in mind that the use of the Format Painter was never necessary until recently? Thank you, FLKulchar
From: Bruce Masteller on 22 Mar 2010 23:14
If there is formatting, you can use Insert Options to choose how to set the formatting of the inserted rows. Another options is to highlight the entire column, then on the home ribbon, click format, format cells, click the number tab, click "time" in the catagory box, then select the type you desire. To get PM you may need to enter the time in military time. "FLKULCHAR" wrote: > I have a spreadsheet that I have used for 5 years...with daily data being > inputted (in newly inserted rows), then Grand Totaled at the bottom of the > spreadsheet. I have never had a problem...UNTIL RECENTLY. > > One of my columns is the time of day, such as 2:54pm, and presently, all of > my inserted rows, except for only 3 of them, depict the time as 2:54 (WITHOUT > THE AM or PM), so, I use the Format Painter, and I Fix the problem...that is, > until the next day, when the same incident again occurs. > > I do not know why this is happening, but I must use this extra step (Format > Painter) to 'fix' the dilemma. > > Can anyone advise me as to how I can avoid this awkward situation...bearing > in mind that the use of the Format Painter was never necessary until recently? > > Thank you, > > FLKulchar |