• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 212
  • Last Modified:

Custom format (value) changes in formula (format)

Hello,

'need some assistance with tweaking a formula/format.   Here's what I have:

Cell F1:  =Today()
Custom format:   yymmdd
Output value: 140805

Now, I concatenate other fields (A1, B1, ..., ..., and F1) in cell M1.    The output for the concatenated F1 value shows, however, 41856 (vs. 140805).

My question:   In the formula (M1), how can I force F1's value to show up is yymmdd?

Thanks,
EEH
0
ExpExchHelp
Asked:
ExpExchHelp
  • 3
  • 2
  • 2
1 Solution
 
NBVCCommented:
In cell M1, use the TEXT function to get that format..

e.g. =A1&B1&C1.... &TEXT(F1,"yymmdd")
0
 
RayData AnalystCommented:
From your example where F1 is your date  . . . .
=A1&B1&C1&D1&E1&TEXT(F1,"yymmdd")
0
 
ExpExchHelpAuthor Commented:
PERFECT!!!!
0
Take Control of Web Hosting For Your Clients

As a web developer or IT admin, successfully managing multiple client accounts can be challenging. In this webinar we will look at the tools provided by Media Temple and Plesk to make managing your clients’ hosting easier.

 
RayData AnalystCommented:
I type too slow ;-)
0
 
ExpExchHelpAuthor Commented:
rlistenb... thank you for chiming in.   I'd have split points but didn't get to see your posting until question closed.   Thank you anyways.   ;)
0
 
NBVCCommented:
You can click "Request Attention" to have a moderator re-open the thread so that you can re-distribute the points if you like.
0
 
ExpExchHelpAuthor Commented:
NBVC... thanks for the info.    Just want to be fair here.   You were the first person who provided a solution.   Guess that means you deserve the points.
0

Featured Post

Take Control of Web Hosting For Your Clients

As a web developer or IT admin, successfully managing multiple client accounts can be challenging. In this webinar we will look at the tools provided by Media Temple and Plesk to make managing your clients’ hosting easier.

  • 3
  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now