Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Custom formatting not functioning in Excel
I have an Excel sheet in which date related formulae were working properly.
But now the Format-Cells-Custom- ddd, d/mmm/yyyy is not accepted by Excel. Date related formattings are not accepted. I have uninstalled Office, defragmented, and reinstalled Office. But problem still persists. Please help me |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Custom formatting not functioning in Excel
What do you mean with "not accepted"? What message do you get?
If the format is accepted but you don't see what you expected, check if your number isn't text (although it may look like a number) with the ISTEXT() function -- Kind regards, Niek Otten "Seenath" wrote in message ... I have an Excel sheet in which date related formulae were working properly. But now the Format-Cells-Custom- ddd, d/mmm/yyyy is not accepted by Excel. Date related formattings are not accepted. I have uninstalled Office, defragmented, and reinstalled Office. But problem still persists. Please help me |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
custom color palette does not get transferred with the workbook. Excel 2003 | Excel Discussion (Misc queries) | |||
Custom Formatting for Dates | Excel Discussion (Misc queries) | |||
Excel 2000 Custom Menu Item | Excel Discussion (Misc queries) | |||
Custom charts - default formatting | Charts and Charting in Excel | |||
Putting Excel formatting and/or formulas into CSV file | Excel Discussion (Misc queries) |