Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Karen
 
Posts: n/a
Default Cannot Format Data in Cell

What could be happening to a cell when this happens?
It's a file someone else created in Excel. I attempted to
center the data in the cell and I can't do that - I can't
even changed the font. I can't figure out what's
happening. There is no protection at all on the cells or
workbook.

HELP!
  #2   Report Post  
JulieD
 
Posts: n/a
Default

Hi Karen

are you trying the centering & bolding on the same piece of text ... check
that you've actually got the text selected by checking as to what appears in
the formula bar - sometimes text isn't where it appears to be ....
if that's not the problem - can you format ANY cell in the worksheet?
can you format cells in a new worksheet?
what version of excel are you using?

Cheers
JulieD

"Karen" wrote in message
...
What could be happening to a cell when this happens?
It's a file someone else created in Excel. I attempted to
center the data in the cell and I can't do that - I can't
even changed the font. I can't figure out what's
happening. There is no protection at all on the cells or
workbook.

HELP!



  #3   Report Post  
Karen
 
Posts: n/a
Default

Hello and thank you for your time - I'm choosing the
correct cell. I have seen this happen before when I'm
trying to change someone else's workbook. I have no idea
what they do to it. I can format some cells and some I
cannot. I can format cells in a new worksheet - I'm
using Word 2003

Thank you
-----Original Message-----
Hi Karen

are you trying the centering & bolding on the same piece

of text ... check
that you've actually got the text selected by checking

as to what appears in
the formula bar - sometimes text isn't where it appears

to be ....
if that's not the problem - can you format ANY cell in

the worksheet?
can you format cells in a new worksheet?
what version of excel are you using?

Cheers
JulieD

"Karen" wrote in

message
...
What could be happening to a cell when this happens?
It's a file someone else created in Excel. I attempted

to
center the data in the cell and I can't do that - I

can't
even changed the font. I can't figure out what's
happening. There is no protection at all on the cells

or
workbook.

HELP!



.

  #4   Report Post  
Paul H
 
Posts: n/a
Default

I've seen this happen if the worksheet was originally
created in Quattro Pro, then converted to Excel. The
workaround is to format a cell that is clear outside of
the original file area, then use the paintbrush to copy
the format to the cell in question.
Hope this helps,
Paul H

-----Original Message-----
Hello and thank you for your time - I'm choosing the
correct cell. I have seen this happen before when I'm
trying to change someone else's workbook. I have no idea
what they do to it. I can format some cells and some I
cannot. I can format cells in a new worksheet - I'm
using Word 2003

Thank you
-----Original Message-----
Hi Karen

are you trying the centering & bolding on the same piece

of text ... check
that you've actually got the text selected by checking

as to what appears in
the formula bar - sometimes text isn't where it appears

to be ....
if that's not the problem - can you format ANY cell in

the worksheet?
can you format cells in a new worksheet?
what version of excel are you using?

Cheers
JulieD

"Karen" wrote in

message
...
What could be happening to a cell when this happens?
It's a file someone else created in Excel. I attempted

to
center the data in the cell and I can't do that - I

can't
even changed the font. I can't figure out what's
happening. There is no protection at all on the cells

or
workbook.

HELP!



.

.

  #5   Report Post  
JulieD
 
Posts: n/a
Default

word or excel???

if word
try
microsoft.public.word.newusers

other option is to format another cell and then use the format painter (big
yellow paint brush on the standard toolbar) to copy the formatting from the
cell you've just formatted to the one where you want it.

Cheers
JulieD

"Karen" wrote in message
...
Hello and thank you for your time - I'm choosing the
correct cell. I have seen this happen before when I'm
trying to change someone else's workbook. I have no idea
what they do to it. I can format some cells and some I
cannot. I can format cells in a new worksheet - I'm
using Word 2003

Thank you
-----Original Message-----
Hi Karen

are you trying the centering & bolding on the same piece

of text ... check
that you've actually got the text selected by checking

as to what appears in
the formula bar - sometimes text isn't where it appears

to be ....
if that's not the problem - can you format ANY cell in

the worksheet?
can you format cells in a new worksheet?
what version of excel are you using?

Cheers
JulieD

"Karen" wrote in

message
...
What could be happening to a cell when this happens?
It's a file someone else created in Excel. I attempted

to
center the data in the cell and I can't do that - I

can't
even changed the font. I can't figure out what's
happening. There is no protection at all on the cells

or
workbook.

HELP!



.



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
Import Data into same cell ib_redbeard Excel Discussion (Misc queries) 3 March 1st 05 12:08 PM
inserting data from a row to a cell, when the row number is specified by a formula in a cell [email protected] New Users to Excel 2 January 6th 05 07:18 AM
Show Blank is cell value=0 but count as a zero in sum. How to format this cell ? Markus Obermayer Excel Discussion (Misc queries) 1 January 4th 05 08:01 PM
Show Blank is cell value=0 but count as a zero in sum. How to format this cell ? Markus Obermayer Excel Worksheet Functions 1 January 4th 05 08:01 PM
GET.CELL Biff Excel Worksheet Functions 2 November 24th 04 07:16 PM


All times are GMT +1. The time now is 03:54 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"