Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formatting in Excel 2007
One of my colleagues imported some data into Excel 2007 and a select few of
records had the correct information when you viewed the cell content in the bar at the top, but when you look at the cell only the last letter would appear. Further changing the alignment or format of the text did not help the matter, what you have to do is clear all formats and then your data will appear correctly in the cell. To clear all formats, make sure you are in the Home tab and select the cells that need to be fixed, then click the arrow next to the eraser tool in the editing section of the ribbon and select Clear Formats. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007 conditional formatting bug? | Excel Discussion (Misc queries) | |||
Conditional Formatting in Excel 2007 | Excel Discussion (Misc queries) | |||
Formatting in Excel 2007 | New Users to Excel | |||
Conditional Formatting in Excel 2007 | Excel Worksheet Functions | |||
Excel 2007 Formatting | Excel Discussion (Misc queries) |