Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default Cell Formatting Incorrectly Displayed

Has anyone come across an issue involving incorrectly displayed formatting?
One particular cell shows Arial, Bold, 9, but does not display as the
adjacent cell with the same formatting. The worksheet does not contain
conditional formatting, does not make use of styles, and there are no
discernable differences except Word Wrap between the formatting on that cell
against the others; however, upon using the Find feature to see if there are
other cells with similar formatting, only that cell is returned in the
results.

This issue can be corrected using the Format Painter, but I would be
interested in knowing what caused this issue and how it can be prevented in
the future. If you would like to see the workbook in question, let me know.
This is my first post to the forum and I do not see where the file can be
posted along with the message.

Thank you!
  #2   Report Post  
Posted to microsoft.public.excel.misc
CLR CLR is offline
external usenet poster
 
Posts: 1,998
Default Cell Formatting Incorrectly Displayed

Copuld be what display you are seeing "in" the cell, is actually a carryover
from the cell to the left of it, formatted differently.....and of course when
you click on the cell you get IT's formatting info, not the one next to
it........

Vaya con Dios,
Chuck, CABGx3



"MINI_Micia" wrote:

Has anyone come across an issue involving incorrectly displayed formatting?
One particular cell shows Arial, Bold, 9, but does not display as the
adjacent cell with the same formatting. The worksheet does not contain
conditional formatting, does not make use of styles, and there are no
discernable differences except Word Wrap between the formatting on that cell
against the others; however, upon using the Find feature to see if there are
other cells with similar formatting, only that cell is returned in the
results.

This issue can be corrected using the Format Painter, but I would be
interested in knowing what caused this issue and how it can be prevented in
the future. If you would like to see the workbook in question, let me know.
This is my first post to the forum and I do not see where the file can be
posted along with the message.

Thank you!

  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,718
Default Cell Formatting Incorrectly Displayed

Shrink to fit? I'd be happy to look at it if you want to email it to me.

--
Jim
"MINI_Micia" wrote in message
...
| Has anyone come across an issue involving incorrectly displayed
formatting?
| One particular cell shows Arial, Bold, 9, but does not display as the
| adjacent cell with the same formatting. The worksheet does not contain
| conditional formatting, does not make use of styles, and there are no
| discernable differences except Word Wrap between the formatting on that
cell
| against the others; however, upon using the Find feature to see if there
are
| other cells with similar formatting, only that cell is returned in the
| results.
|
| This issue can be corrected using the Format Painter, but I would be
| interested in knowing what caused this issue and how it can be prevented
in
| the future. If you would like to see the workbook in question, let me
know.
| This is my first post to the forum and I do not see where the file can be
| posted along with the message.
|
| Thank you!


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
Problems changing cell formatting SteveB Excel Discussion (Misc queries) 3 April 25th 06 05:13 PM
Urgent date/scheduling calc needed jct Excel Worksheet Functions 3 February 24th 06 01:36 AM
Possible Lookup Table Karen Excel Worksheet Functions 5 June 8th 05 09:43 PM
cell formatting problems jazzsax505 New Users to Excel 2 May 29th 05 10:30 PM
Cell formatting behaviour question derek Excel Discussion (Misc queries) 3 February 22nd 05 10:17 PM


All times are GMT +1. The time now is 04:20 PM.

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

About Us

"It's about Microsoft Excel"