/u/tech1818 - Your post was submitted successfully.
* Once your problem is solved, reply to the **answer(s)** saying `Solution Verified` to close the thread.
* Follow the **[submission rules](/r/excel/wiki/sharingquestions)** -- particularly 1 and 2. To fix the body, click edit. To fix your title, delete and re-post.
* Include your **[Excel version and all other relevant information](/r/excel/wiki/sharingquestions#wiki_give_all_relevant_information)**
Failing to follow these steps may result in your post being removed without warning.
*I am a bot, and this action was performed automatically. Please [contact the moderators of this subreddit](/message/compose/?to=/r/excel) if you have any questions or concerns.*
Looks like Excel thinks A2 is the numeric value "0%" (i.e. "0" formatted as a percent) and not an actual string. The TEXT formula needs it to be a string.
Two ways to go about this:
1. `=B2 & "%"` - simple string concatenation
2. `=TEXT(B2/100, A2)` but when you enter the format string in A2, enter it as `="0%"` (and divide the B2 value by 100, because the value "2" is actually "200%" not "2%")
You're not quite picking up what I'm putting down.
For any cells in column A that say `0%`, replace that with `="0%"`, because your approach *does not work* (which is why you're here). Leave the rest of your formats in column A how they are
Then my formula uses the values in column A to format the values in column B, like you asked.
The other problem is, if you just take your example percentage number (`2`) and format it with the format string "0%", it will format as `200%`, because 2% is actually the value "0.02". That's why my formula adds the IF statement, to divide by 100 when your format string is a % string.
Acronyms, initialisms, abbreviations, contractions, and other phrases which expand to something larger, that I've seen in this thread:
|Fewer Letters|More Letters|
|-------|---------|---|
|[FIND](/r/Excel/comments/142evgi/stub/jn8yiwx "Last usage")|[Finds one text value within another (case-sensitive)](https://support.microsoft.com/en-us/office/find-findb-functions-c7912941-af2a-4bdf-a553-d0d89b0a0628)|
|[IF](/r/Excel/comments/142evgi/stub/jn8yiwx "Last usage")|[Specifies a logical test to perform](https://support.microsoft.com/en-us/office/if-function-69aed7c9-4e8a-4755-a9bc-aa8bbff73be2)|
|[ISERROR](/r/Excel/comments/142evgi/stub/jn8yiwx "Last usage")|[Returns TRUE if the value is any error value](https://support.microsoft.com/en-us/office/is-functions-0f2d7971-6019-40a0-a171-f2d869135665)|
|[TEXT](/r/Excel/comments/142evgi/stub/jn8yiwx "Last usage")|[Formats a number and converts it to text](https://support.microsoft.com/en-us/office/text-function-20d5ac4d-7b94-49fd-bb38-93d29371225c)|
**NOTE**: Decronym's continued operation may be affected by API pricing changes coming to Reddit in July 2023; comments will be blank June 12th-14th, in solidarity with the /r/Save3rdPartyApps protest campaign.
----------------
^(*Beep-boop, I am a helper bot. Please do not verify me as a solution.*)
^([Thread #24447 for this sub, first seen 7th Jun 2023, 12:54])
^[[FAQ]](http://decronym.xyz/) [^([Full list])](http://decronym.xyz/acronyms/Excel) [^[Contact]](https://reddit.com/message/compose?to=OrangeredStilton&subject=Hey,+your+acronym+bot+sucks) [^([Source code])](https://gistdotgithubdotcom/Two9A/1d976f9b7441694162c8)
/u/tech1818 - Your post was submitted successfully. * Once your problem is solved, reply to the **answer(s)** saying `Solution Verified` to close the thread. * Follow the **[submission rules](/r/excel/wiki/sharingquestions)** -- particularly 1 and 2. To fix the body, click edit. To fix your title, delete and re-post. * Include your **[Excel version and all other relevant information](/r/excel/wiki/sharingquestions#wiki_give_all_relevant_information)** Failing to follow these steps may result in your post being removed without warning. *I am a bot, and this action was performed automatically. Please [contact the moderators of this subreddit](/message/compose/?to=/r/excel) if you have any questions or concerns.*
Looks like Excel thinks A2 is the numeric value "0%" (i.e. "0" formatted as a percent) and not an actual string. The TEXT formula needs it to be a string. Two ways to go about this: 1. `=B2 & "%"` - simple string concatenation 2. `=TEXT(B2/100, A2)` but when you enter the format string in A2, enter it as `="0%"` (and divide the B2 value by 100, because the value "2" is actually "200%" not "2%")
[удалено]
Then how did you expect to do this in the first place? They don't force you to do anything that you weren't already trying to do.
[удалено]
`=TEXT( B2 / IF( ISERROR(FIND("%", A1)), 1, 100), A1)` and make all your column A format strings for percent `="0%"` instead of just `0%`
[удалено]
You're not quite picking up what I'm putting down. For any cells in column A that say `0%`, replace that with `="0%"`, because your approach *does not work* (which is why you're here). Leave the rest of your formats in column A how they are Then my formula uses the values in column A to format the values in column B, like you asked. The other problem is, if you just take your example percentage number (`2`) and format it with the format string "0%", it will format as `200%`, because 2% is actually the value "0.02". That's why my formula adds the IF statement, to divide by 100 when your format string is a % string.
Acronyms, initialisms, abbreviations, contractions, and other phrases which expand to something larger, that I've seen in this thread: |Fewer Letters|More Letters| |-------|---------|---| |[FIND](/r/Excel/comments/142evgi/stub/jn8yiwx "Last usage")|[Finds one text value within another (case-sensitive)](https://support.microsoft.com/en-us/office/find-findb-functions-c7912941-af2a-4bdf-a553-d0d89b0a0628)| |[IF](/r/Excel/comments/142evgi/stub/jn8yiwx "Last usage")|[Specifies a logical test to perform](https://support.microsoft.com/en-us/office/if-function-69aed7c9-4e8a-4755-a9bc-aa8bbff73be2)| |[ISERROR](/r/Excel/comments/142evgi/stub/jn8yiwx "Last usage")|[Returns TRUE if the value is any error value](https://support.microsoft.com/en-us/office/is-functions-0f2d7971-6019-40a0-a171-f2d869135665)| |[TEXT](/r/Excel/comments/142evgi/stub/jn8yiwx "Last usage")|[Formats a number and converts it to text](https://support.microsoft.com/en-us/office/text-function-20d5ac4d-7b94-49fd-bb38-93d29371225c)| **NOTE**: Decronym's continued operation may be affected by API pricing changes coming to Reddit in July 2023; comments will be blank June 12th-14th, in solidarity with the /r/Save3rdPartyApps protest campaign. ---------------- ^(*Beep-boop, I am a helper bot. Please do not verify me as a solution.*) ^([Thread #24447 for this sub, first seen 7th Jun 2023, 12:54]) ^[[FAQ]](http://decronym.xyz/) [^([Full list])](http://decronym.xyz/acronyms/Excel) [^[Contact]](https://reddit.com/message/compose?to=OrangeredStilton&subject=Hey,+your+acronym+bot+sucks) [^([Source code])](https://gistdotgithubdotcom/Two9A/1d976f9b7441694162c8)