How do I convert a year (YYYY) in a cell to MM/DD/YYYY format? Is there a formula that will do this?
E eric Jan 27, 2007 #1 How do I convert a year (YYYY) in a cell to MM/DD/YYYY format? Is there a formula that will do this?
N Niek Otten Jan 27, 2007 #2 =DATE(A1,1,1) -- Kind regards, Niek Otten Microsoft MVP - Excel | How do I convert a year (YYYY) in a cell to MM/DD/YYYY format? Is | there a formula that will do this? |
=DATE(A1,1,1) -- Kind regards, Niek Otten Microsoft MVP - Excel | How do I convert a year (YYYY) in a cell to MM/DD/YYYY format? Is | there a formula that will do this? |