Comments on Yogesh Gupta's Excel Tips: Format Numbers : Excel Currency Format

Thanks Rick - I would have never found it. Thank...

2010-04-19T05:29:06.190+05:30

Thanks Rick - I would have never found it.

Thanks Yogesh for a helpful site.

@Vijay, Yogesh, You can use this formula to perfo...

2010-04-18T21:34:18.453+05:30

@Vijay, Yogesh,

You can use this formula to perform the summation (just change the range to encompass your cells...

=SUMPRODUCT(1*SUBSTITUTE(A1:A1000,"<",""))

Hi Vijay Excel does not recoganise numbers with &...

2010-04-18T20:59:59.075+05:30

Hi Vijay

Excel does not recoganise numbers with "<" sign as numbers and will not include them in calculation. You will need to remove them before getting them included into calculation.

Some simple steps to remove them quicly are :-

1. Select the cells or entire range with numbers having "<" before them.
2. Press Ctrl+H
3. write < in find value
4. Leave replace value as blank and press replace all button

You will have this removed from all the numbers and excel will recoginse them as numbers that can be used by formulas.

I hope this helps, let me know in case any further help

Regards//Yogesh Gupta

Hi, How can I sum the numbers in a column in Exce...

2010-04-18T19:51:40.928+05:30

Hi,

How can I sum the numbers in a column in Excel where some numbers carry a "<" sign in front of them (such as <1) and I want to include numbers such "<1" in calculation as "1".

For Example if numbers are entered as follows

0.5
<1
0.5

I would like to value to be returned as "2" when I apply "sum" function.

Thanks

If I am not mistaken the Rs. symbol will be there ...

2010-03-09T11:43:00.511+05:30

If I am not mistaken the Rs. symbol will be there as per International settings in Control Panel.

Also http://www.dq.winsila.com/tips-tricks/an-excel-addin-to-show-currency-in-indian-format-and-words.html is a great resource to have.

Regards,

Ninad.

PS.: BTW, your posts at PHD are welcomed.