| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Crazy Formatting Issue!
It won't format until I double click it to get to edit, THEN click off. Just take a look, it boggles my mind!!! http://ga.uno.edu/EVIL.xls -- Beefeater ------------------------------------------------------------------------ Beefeater's Profile: http://www.excelforum.com/member.php...o&userid=35423 View this thread: http://www.excelforum.com/showthread...hreadid=551910 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Crazy Formatting Issue!
Hi
One way is to select the whole range. Press F2 and then Ctrl+Enter. Another is to copy a blank unused cell, select your range and then Edit/Paste Special/Add. Then format the range as date as required. Andy. "Beefeater" wrote in message ... It won't format until I double click it to get to edit, THEN click off. Just take a look, it boggles my mind!!! http://ga.uno.edu/EVIL.xls -- Beefeater ------------------------------------------------------------------------ Beefeater's Profile: http://www.excelforum.com/member.php...o&userid=35423 View this thread: http://www.excelforum.com/showthread...hreadid=551910 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Cell formatting issue | Excel Discussion (Misc queries) | |||
| formatting issue? | Excel Discussion (Misc queries) | |||
| cannot delete condional formatting | Excel Discussion (Misc queries) | |||
| conditional formatting question | Excel Discussion (Misc queries) | |||
| Copy conditional formatting across multiple rows? | Excel Discussion (Misc queries) | |||
Hybrid Mode
