![]() |
#3
|
||||
|
||||
![]()
Thank you for giving three options, from which I chose formula number 1. The second and third formula compute Dec 1937 as 13850 even if it is formatted as text.
|
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
Concatenate to reference values with that are dates | Glitch | Excel Programming | 3 | 08-03-2018 02:58 PM |
IF formula when some values are text & others $ amounts | LyndaH | Excel | 4 | 03-26-2017 08:31 PM |
How to convert VLOOKUP values to text on another sheet AUTOMATICALLY | Lady18 | Excel | 5 | 09-10-2016 03:12 AM |
![]() |
Lady18 | Excel | 1 | 09-10-2016 12:15 AM |
Convert Formula Result to Static Text | MYGS | Excel | 16 | 01-21-2013 08:18 AM |