Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
1) Copy the following paragraph to cells A1 and A2 (be sure to remove the
line breaks that this web site adds): Placing this project in yellow as Company ABC has NOT provided as yet, the T&C1 to the MOM. Both have been overdue since mid-June. Escalations within Company ABC and from Company XYZ leadership has not changed the status. Meanwhile, Company ABC PM is reporting that INSTAR test support is an issue. Sahni has escalated numerous times on both issues. 2) Format A1 with the General format; format A2 with the Text format. Notice that A1 looks normal, but A2 shows ########################### 3) Now copy the following paragraph to cells A3 and A4 (again be sure to remove the line breaks that this web site adds): 10/31 [tm0622] - Request for swBRD to be baselined via e-mail, because it is late. 10/23 - swBRD - not baselined, T&C (1) to be delivered 7 days from baselining. 4) Format A3 with the General format; format A4 with the Text format. Notice that A1 and A2 both look normal! Can anyone tell me what is going on here? Any help in solving this mystery would be greatly appreciated. Thanks, Bob |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Text entries behaving like numbers | Excel Discussion (Misc queries) | |||
Format: General - Text - General | Excel Worksheet Functions | |||
converting general cells format to text | Excel Discussion (Misc queries) | |||
grayscale conditional formatting of text | Excel Discussion (Misc queries) | |||
Concatenation formula loses text wrap formatting | Excel Discussion (Misc queries) |