expertatexcel.com

format

Is a function to make data more readable via the format function

Applies to numbers and dates

mm/dd/yy

ddd - day of week

Immediate Window



? format(#3/21/21#,"ddd")

Sun



? format(012313,"#,

#0")

12,313



? format(012313,"000000")

012313



? format(12313,"000000")

012313



? format("3/21/21","mm/dd/yyyy")

03/21/2021



? format(now(),"yyyy-mm-dd")

2021-04-06



?formate(now(),"hh:mm")



?format(now(),"hh:mm")

14:06



?format(now(),"hh:mm:ss am/pm")

02:06:37 pm