| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
rearrange values in cell to date
In what way is it "not a date"... does it have an apostrophe in front of it
(look in the Formula Bar, not the cell, to see it this is the case) or is the cell formatted as Text? -- Rick (MVP - Excel) "J.W. Aldridge" wrote in message ... uploaded cell values in column B show as 2009-04-11 (does not read as a date) Need code that will check to see if any value as above exist in column B, if so change order to format that reads as a date. 04/11/2009 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| rearrange texts and values in new column | Excel Discussion (Misc queries) | |||
| Create a formula to rearrange different values in groups | Excel Discussion (Misc queries) | |||
| rearrange date | Excel Discussion (Misc queries) | |||
| help me on rearrange cells based on its numerical values without repeating any number | Excel Programming | |||
| help me on rearrange cells based on its numerical values without repeating any number | Excel Worksheet Functions | |||
Hybrid Mode
