| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Some cells can't be formatted after converting from Quattro Pro.
I downloaded a converter from the web to convert a Quattro Pro 8.0
spreadsheat to Excel 2002. Now there are certain cells that I cannot fromat. I use the format cells command but nothing happens. The cells were not locked in Quattro Pro. |
|
#2
|
|||
|
|||
|
After formatting, you can re-enter the cell (F2/Enter)
"slock@muccipac" wrote: I downloaded a converter from the web to convert a Quattro Pro 8.0 spreadsheat to Excel 2002. Now there are certain cells that I cannot fromat. I use the format cells command but nothing happens. The cells were not locked in Quattro Pro. |
|
#3
|
|||
|
|||
|
Quote:
Anywho, the real answer...... as I'm quite familiar with this problem. It has to do with cells that have borders. This causes a bug preventing the cells from being formatted. Copy the sheet you want and "paste special" to a new sheet and choose "All except borders". The new sheet can then be formatted. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| monitoring a changing range of cells | Excel Discussion (Misc queries) | |||
| Locked cells not updating | Excel Worksheet Functions | |||
| Heps to design Locked/Unlocked cells in protected worksheet | Excel Discussion (Misc queries) | |||
| Convert data of cells to any type: Number, Date&Time, Text | Excel Discussion (Misc queries) | |||
| Count number of shaded cells | Excel Discussion (Misc queries) | |||
Linear Mode
