| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Converting a cell value
On Sun, 2 Nov 2008 01:19:57 -0500, "Rick Rothstein"
wrote: If we assume the OP has not modified the normal break point for determining the century in his Windows regional setting (default is the 30 you are using in your formula), then this shorter formula can be used... =YEAR("1/1/"&A1) -- Rick (MVP - Excel) True. But I wonder which would execute more quickly. :-) --ron |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Converting a date to a text field w/o converting it to a julian da | Excel Worksheet Functions | |||
| Converting a Cell Value to a Different Value | Excel Worksheet Functions | |||
| Converting a cell into a comment | Excel Discussion (Misc queries) | |||
| Cell borders when converting 123 doc to xls | Excel Discussion (Misc queries) | |||
| Converting cell ref. w/num to currency | Excel Worksheet Functions | |||
Hybrid Mode
