| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
unable to change format of a cell
Hi all. In my excel sheet i select format all cells by going to the number
tab and select number category and set the format i want under 'negative numbers' section. Satisfied with the changes I then saved my excel sheet. However when i open the same file again i could see some of the cells showing ¥(yen) sign together with the number in the cell. I went back to format the cell by going to number tab and number category again and set to the format i want. After seeing the results i saved, but when i open the file it is still having the same yen problem. Why is this so? How can i solve this? I am using excel 2003. Thks in advance. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
unable to change format of a cell
I can't imagine why this would happen, but if it happened to me, I'd
probably try Edit--Clear--All and re-enter the value(s). Then save, then format properly, then save, close, and reopen to test. **************************** Hope it helps! Anne Troy www.OfficeArticles.com **************************** "inenewbl" wrote in message ... Hi all. In my excel sheet i select format all cells by going to the number tab and select number category and set the format i want under 'negative numbers' section. Satisfied with the changes I then saved my excel sheet. However when i open the same file again i could see some of the cells showing ¥(yen) sign together with the number in the cell. I went back to format the cell by going to number tab and number category again and set to the format i want. After seeing the results i saved, but when i open the file it is still having the same yen problem. Why is this so? How can i solve this? I am using excel 2003. Thks in advance. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Lock Cell Format - Allow copy and paste of data without format change | Excel Worksheet Functions | |||
| cant change the cell format it shows too many different cell form | Excel Worksheet Functions | |||
| Can cell format come from and change with reference cell format | Excel Discussion (Misc queries) | |||
| unable to change date format on imported data | Excel Discussion (Misc queries) | |||
| unable to change data in cell(s) | Excel Discussion (Misc queries) | |||
Hybrid Mode
