| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Format cells to General?
It seems, at least for me, that formatting cells to "General" is nearly
impossible to maintain. I set a cell (or thousands of cells) to "General" format for formula's. Any time my self, another user or a macro alters the values in the cell the format changes back to "Text"!? What the heck! Is there a fix? -- Regards VBA.Noob.Confused XP Pro Office 2007 Brain 1961 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Format cells to General?
P.S.
Setting the cell to"General" prior to entering any data doesn't eleviate the problem at all. (Something MS told me to do). -- Regards VBA.Noob.Confused XP Pro Office 2007 "Rick S." wrote: It seems, at least for me, that formatting cells to "General" is nearly impossible to maintain. I set a cell (or thousands of cells) to "General" format for formula's. Any time my self, another user or a macro alters the values in the cell the format changes back to "Text"!? What the heck! Is there a fix? -- Regards VBA.Noob.Confused XP Pro Office 2007 Brain 1961 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to convert data in General Format cells to dates | Excel Discussion (Misc queries) | |||
| Format: General - Text - General | Excel Worksheet Functions | |||
| excel numbers in general format i cant add cant change format | Excel Worksheet Functions | |||
| converting general cells format to text | Excel Discussion (Misc queries) | |||
| How can I keep a cells format, general, from changing after enter. | Excel Discussion (Misc queries) | |||
Linear Mode
