| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
reformatting "text" format for dates and numeric data
For the numeric entries you can do something like:
With yourrange .NumberFormat = "General" .Value = .Value End With this will convert the dates, but depending on your regional settings and what was entered into the cell, they may not be accurate. It will convert anything excel recognizes as a date to the number that represents the date that excel thinks it is. Cliff Edwards |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| retain custom date format "text" when pasting or reformatting data | Excel Discussion (Misc queries) | |||
| Excel: Changing "numeric $" to "text $" in a different cell. | Excel Worksheet Functions | |||
| If A3=alpha numeric,"X", if A3=text,"Y", Blank | Excel Worksheet Functions | |||
| If A3=alpha numeric,"X", if A3=text,"Y", Blank | Excel Programming | |||
| Stop autoformatted dates without using "format TEXT" or ' | Excel Discussion (Misc queries) | |||
Threaded Mode
