| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Can't change cell value with unusual font.
Hello,
I have a cell value that I am unable to modify. Cell A1 = Ｄ３８９９９／２０ＫＨ５３ＳＡ w/font "*Ｓ Ｐゴシック" (a font not installed in the system) Cell B1 = D38999/26FA35PN w/font "Arial 10pt" I want to split A1's cell by using the "/" as a delimiter and change the font. B1 reacts normally to changes, A1 won't react to my changes. Also, Edit-Replace doesn't work on the "/". Changing the font doesn't work. Clearing formats won't work. A1 is not locked and the sheet is not protected. Hmm, tis a mystery! Thank you for your help, Terri |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| I Need a formula to evaluate a cell with + or - values | Excel Worksheet Functions | |||
| SQL - Auto Refresh Upon Cell Value Change | Excel Worksheet Functions | |||
| change font color of first cell in data table attached to chart | Charts and Charting in Excel | |||
| Change cell back color on click | Excel Discussion (Misc queries) | |||
| Change Font Size | Excel Worksheet Functions | |||
Threaded Mode
