| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to format cells to General via vba
Some cells are pasted in from external sources as a date. I used the
record and play option but it didn't pick up how to format cells as General. How is this possible? Thanks |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to format cells to General via vba
rng.NumberFormat = "General"
Regards, Peter T "Simon" wrote in message ... Some cells are pasted in from external sources as a date. I used the record and play option but it didn't pick up how to format cells as General. How is this possible? Thanks |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to format cells to General via vba
On Aug 5, 5:36*pm, "Peter T" wrote:
rng.NumberFormat = "General" Regards, Peter T "Simon" wrote in message ... Some cells are pasted in from external sources as a date. *I used the record and play option but it didn't pick up how to format cells as General. How is this possible? Thanks- Hide quoted text - - Show quoted text - Cheers Pete |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pasting HTML script to Excel 2007 converts the cells format to 'General' | Excel Discussion (Misc queries) | |||
| Format cells to General? | Excel Worksheet Functions | |||
| How to convert data in General Format cells to dates | Excel Discussion (Misc queries) | |||
| 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) | |||
![Simon[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
