Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Ted Metro
 
Posts: n/a
Default Adding + in front of a number

I have a column of numbers which represent a change in value over the
previous year. I want to have a + in front of the number if it's a positive
change.
Let's say my first number is 500.

My problem is that I can write something like, if(a10,"+"&a1), but when
then I can't format the number.

If the number is in the millions I can't provide a comma as a thousand
separator and I cannot tell it how many decimal places I want to show. Is
there a really easy way to do that, or do I have to write a huge formula to
precisely spell out the formatting within the formula?
  #2   Report Post  
Frank Kabel
 
Posts: n/a
Default

Hi
try a custom format such as:
+0.00;-0.00;0.00

--
Regards
Frank Kabel
Frankfurt, Germany
"Ted Metro" schrieb im Newsbeitrag
...
I have a column of numbers which represent a change in value over the
previous year. I want to have a + in front of the number if it's a
positive
change.
Let's say my first number is 500.

My problem is that I can write something like, if(a10,"+"&a1), but when
then I can't format the number.

If the number is in the millions I can't provide a comma as a thousand
separator and I cannot tell it how many decimal places I want to show. Is
there a really easy way to do that, or do I have to write a huge formula
to
precisely spell out the formatting within the formula?



  #3   Report Post  
Jason Morin
 
Posts: n/a
Default

Custom format your cells as:

+#,##0;-#,##0;0;@

HTH
Jason
Atlanta, GA

-----Original Message-----
I have a column of numbers which represent a change in

value over the
previous year. I want to have a + in front of the

number if it's a positive
change.
Let's say my first number is 500.

My problem is that I can write something like, if

(a10,"+"&a1), but when
then I can't format the number.

If the number is in the millions I can't provide a comma

as a thousand
separator and I cannot tell it how many decimal places I

want to show. Is
there a really easy way to do that, or do I have to

write a huge formula to
precisely spell out the formatting within the formula?
.

  #4   Report Post  
Ted Metro
 
Posts: n/a
Default

you guys rule. Thanks Jason!!!

Thanks Frank!!




"Jason Morin" wrote:

Custom format your cells as:

+#,##0;-#,##0;0;@

HTH
Jason
Atlanta, GA

-----Original Message-----
I have a column of numbers which represent a change in

value over the
previous year. I want to have a + in front of the

number if it's a positive
change.
Let's say my first number is 500.

My problem is that I can write something like, if

(a10,"+"&a1), but when
then I can't format the number.

If the number is in the millions I can't provide a comma

as a thousand
separator and I cannot tell it how many decimal places I

want to show. Is
there a really easy way to do that, or do I have to

write a huge formula to
precisely spell out the formatting within the formula?
.


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Seed numbers for random number generation, uniform distribution darebo Excel Discussion (Misc queries) 3 April 21st 23 09:02 PM
Subtracting based on number of miles Ms Chewie Excel Discussion (Misc queries) 3 December 21st 04 06:35 AM
How to format a number in Indian style in Excel? Victor_alb Excel Discussion (Misc queries) 2 December 21st 04 05:21 AM
Count number of shaded cells Maddoktor Excel Discussion (Misc queries) 2 December 20th 04 09:35 PM
Use Julian Date To Create Serial Number antho10359 Excel Discussion (Misc queries) 4 December 9th 04 02:50 AM


All times are GMT +1. The time now is 09:37 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"