Ask a new question

Excel 2016: TEXT Function

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?

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.

***********
AI: Artificial Intelligence or Automated Idiocy???

Few tools work well if you don’t learn to use them.

"A little knowledge is a dangerous thing." - Alexander Pope

Regards,
Bob J.

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

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

1 person found this reply helpful

·

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

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 - Advanced to 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?

***********
AI: Artificial Intelligence or Automated Idiocy???

Few tools work well if you don’t learn to use them.

"A little knowledge is a dangerous thing." - Alexander Pope

Regards,
Bob J.

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

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.

If my reply has helped, mark accordingly - Helpful or Answer
Phillip M. Jones, C.E.T.

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

 
 

Question Info

Last updated June 15, 2023 Views 638 Applies to: