|
|
#1
02-27-2019, 04:03 PM
|
||||
|
||||
Format in a formula month and numbers
Hi all, below is a formula concatenating values from 2 columns. It returns a string like 2019-1-1. I would like the result to appear as 2019-01-001. I tried inserting TEXT before the month and number but I always come up with "too many arguments" message. Kindly check my formula. Thank you.
Code:
=YEAR([@Date])&"-"&MONTH([@Date])&"-"&[@ObR] 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Need Help Deleting Numbers in Hour Format and Numbers in Sequence | rsrasc | Word VBA | 1 | 10-12-2016 02:49 PM |
 Formula For Displaying Exact Days of the Month
|
ddhawks | Excel | 2 | 07-12-2016 11:48 PM |
|
Formula to divide if no of days in month is 28
|
shilabrow | Excel | 5 | 06-26-2014 12:17 AM |
| Formula to count entries as per month, year and submission wise from different sheets | pinkacidpunk | Excel | 1 | 05-28-2013 08:26 AM |
| Formula to subtract one month from due date field in reminder field | ghumdinger | Outlook | 1 | 10-01-2011 12:09 AM |
Windows 7 32bit 
Office 2007
Threaded Mode