Hello ,
I need to display value as percentage could you please help me on attached
file.
Thank you,
Chandru
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
Hi Chandra Shekar,
Use this formula :
=A1 %
Regards
Ashish
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread
Hey Ashish, Dont you think it will be converted to text if you use that
formula.
On Monday, November 24, 2014 5:50:29 PM UTC+5:30, Ashish Kumar wrote:
Hi Chandra Shekar,
Use this formula :
=A1 %
Regards
Ashish
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be?
Dear Mandeep,
Are you trying this formula.
Regards
Ashish
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles.
Nopz but I just want to learn new things if it works bro.
On Monday, November 24, 2014 6:06:55 PM UTC+5:30, Ashish Kumar wrote:
Dear Mandeep,
Are you trying this formula.
Regards
Ashish
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) !
Hi Mandeep,
If your Data in Cell A1 then put the formula in B1. This is concatenate
function. Try it...!!
Regards
Ashish
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
,
As long as ever you can.” - John Wesley
-
From: Chandra Shekar chandrashekarb@gmail.com
To: excel-macros@googlegroups.com
Sent: Monday, November 24, 2014 7:11 AM
Subject: $$Excel-Macros$$ Changing value to percentage
Hello ,
I need to display
*
-
*From:* Chandra Shekar chandrashekarb@gmail.com
*To:* excel-macros@googlegroups.com
*Sent:* Monday, November 24, 2014 7:11 AM
*Subject:* $$Excel-Macros$$ Changing value to percentage
Hello ,
I need to display value as percentage could you
-
From: Chandra Shekar chandrashekarb@gmail.com
To: excel-macros@googlegroups.com
Sent: Monday, November 24, 2014 9:57 AM
Subject: Re: $$Excel-Macros$$ Changing value to percentage
Hello All,
I want it as value not text and am not adding with any value just I need to
display it as value
Chandru find the attachemnt ihad get given above it will take the format as
value. Ashish i know that its a concatenate function but as you are not aware
about the fact whenever a concatenate function is used with text that value
turned into a text .
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT))
-
From: Mandeep Baluja rockerna...@gmail.com
To: excel-macros@googlegroups.com
Sent: Monday, November 24, 2014 10:59 AM
Subject: Re: $$Excel-Macros$$ Changing value to percentage
Chandru find the attachemnt ihad get given above it will take the format
-Macros$$ Changing value to percentage
Chandru find the attachemnt ihad get given above it will take the format
as value. Ashish i know that its a concatenate function but as you are not
aware about the fact whenever a concatenate function is used with text that
value turned into a text
12 matches
Mail list logo