Share via

Excel 2016: TEXT Function

Anonymous
2015-08-06T12:27:50+00:00

I'm trying to convert a number to a weekday name. I found the TEXT function for this.

It kept giving me error messages. Now I've got it doen to a two-cell problem.

Nothing I try with the TEXT funtion works. Even just copying the formula from the Help text ( = TEXT(A1,"$0,00") ) gives me "Your formula contians an error". I can't get any of the TEXT examples from the help text to work.

Is "TEXT" broken?

Microsoft 365 and Office
Microsoft 365 and Office

A comprehensive suite of productivity tools and cloud services that enhance collaboration, communication, and efficiency. Combining classic Office apps with advanced Microsoft 365 features, it supports both personal and business needs

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

4 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2015-08-06T14:45:09+00:00

    Hi.

    As I wrote, I've been trying a lot of different things and tried to boil it down to the most general problem description.

    "$0,00" and "$0.00" both give the same error message.

    TEXT(A1,"ddd") ALSO gives me "The formula you typed contains an error".

    (yes, I made sure that A1 contains a date, which is also formatted as a date).

    The bubble tip suggests that maybe "TEXT(A1;"ddd")" would be the correct format (semicolon instead of comma).

    This just writes "ddd" in the cell :-)

    Daniel

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments
  2. Anonymous
    2015-08-06T19:13:45+00:00

    I tried this in both 2011 and 2016  But I used the insert Function method as opposed to typing everything. and I Formatted both A1 and B1 as Date (*3/4/15 — Not the actual numbers represented in the format window but notice the asterisk ) later on list is identical setup without the asterisk.)

    Excel 2011:

    Excel 2016:

    _________

    Disclaimer:

    The questions, discussions, opinions, replies & answers I create, are solely mine and mine alone, and do not reflect upon my position as a Community Moderator.

    Was this answer helpful?

    0 comments
  3. Bob Jones AKA CyberTaz MVP 436K Reputation points
    2015-08-06T18:53:04+00:00

    Well, I'm not sure what to tell you... As you can see from this screenshot, having the date in A1 the formula in A6 (as shown in the Formula Bar) returns the abbreviation Thu. Similarly, using the "dddd" format returns the complete word Thursday.

    I can't reproduce what you're experiencing without intentionally making a syntax error.

    Is your installation of Office current [15.12.3]?

    Are there similar issues with other functions?

    Have you checked your OS X System Preferences> Language & Region - Advancedto make sure they are what they should be?

    Can you put a copy of the file on a cloud (such as OneDrive or Dropbox) & share a link?

    Was this answer helpful?

    0 comments
  4. Bob Jones AKA CyberTaz MVP 436K Reputation points
    2015-08-06T14:26:10+00:00

    My guess is that there is a conflict with what you're entering & your OS X Region formats...

    What you're pasting uses a period in the formula's format argument ["$0**.00"] but what you typed in your message uses a comma ["$0,**00"].

    If you're trying to return a day name, though, that wouldn't make a difference because a completely different format would be used. E.g., if cell A1 contains 8/6/15 the formula =Text(A1,"dddd") would return Thursday.

    Was this answer helpful?

    0 comments