Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula Help
Dear all,
I do have a file containing cheques value as by encoded it shows figures in dollers & sents without decimal points. I want to convert it to value with decimal points. value value to be converted into 50000 500.00 I tried by formatting it to Number with 2 decimal points by it adds 2 more Zeros and value looks 50000.00. I tried a lot but nothing happening please help me. Thanks in advance, Aarif |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula Help
"aarif" skrev i en meddelelse
... Dear all, I do have a file containing cheques value as by encoded it shows figures in dollers & sents without decimal points. I want to convert it to value with decimal points. value value to be converted into 50000 500.00 I tried by formatting it to Number with 2 decimal points by it adds 2 more Zeros and value looks 50000.00. I tried a lot but nothing happening please help me. Thanks in advance, Aarif Hello Aarif You can't do it with formatting. Formatting doesn't change the underlying value, it just displays it in different clothings so to speak. Try this setup: In A2: 50000 In B2: =A2/2 Format B2 with 2 decimals. -- Best regards Leo Heuser Followup to newsgroup only please. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula Help
Sorry, it should of course be:
In A2: 50000 In B2: =A2/100 Format B2 with 2 decimals. Leo Heuser "Leo Heuser" skrev i en meddelelse ... "aarif" skrev i en meddelelse ... Dear all, I do have a file containing cheques value as by encoded it shows figures in dollers & sents without decimal points. I want to convert it to value with decimal points. value value to be converted into 50000 500.00 I tried by formatting it to Number with 2 decimal points by it adds 2 more Zeros and value looks 50000.00. I tried a lot but nothing happening please help me. Thanks in advance, Aarif Hello Aarif You can't do it with formatting. Formatting doesn't change the underlying value, it just displays it in different clothings so to speak. Try this setup: In A2: 50000 In B2: =A2/2 Format B2 with 2 decimals. -- Best regards Leo Heuser Followup to newsgroup only please. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula Help
Hi Loe,
Thanks a lot for helping me and for helping so quickly because I have to complete my work in today itself and did not know how to make it possible. I was not expected that anyone will reply me so quickly. You saved my life. Thank you very very much. Aarif "Leo Heuser" wrote: Sorry, it should of course be: In A2: 50000 In B2: =A2/100 Format B2 with 2 decimals. Leo Heuser "Leo Heuser" skrev i en meddelelse ... "aarif" skrev i en meddelelse ... Dear all, I do have a file containing cheques value as by encoded it shows figures in dollers & sents without decimal points. I want to convert it to value with decimal points. value value to be converted into 50000 500.00 I tried by formatting it to Number with 2 decimal points by it adds 2 more Zeros and value looks 50000.00. I tried a lot but nothing happening please help me. Thanks in advance, Aarif Hello Aarif You can't do it with formatting. Formatting doesn't change the underlying value, it just displays it in different clothings so to speak. Try this setup: In A2: 50000 In B2: =A2/2 Format B2 with 2 decimals. -- Best regards Leo Heuser Followup to newsgroup only please. |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula Help
You are welcome, Aarif, and thanks for the feedback :-)
Leo "aarif" skrev i en meddelelse ... Hi Loe, Thanks a lot for helping me and for helping so quickly because I have to complete my work in today itself and did not know how to make it possible. I was not expected that anyone will reply me so quickly. You saved my life. Thank you very very much. Aarif |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula Help
Without formulas..................
Enter 100 in an unused cell. Copy that cell. Select your other numbers and Paste SpecialDivideOKEsc. Dekete the cell with 100 Gord Dibben MS Excel MVP On Sat, 12 Aug 2006 01:47:02 -0700, aarif wrote: Hi Loe, Thanks a lot for helping me and for helping so quickly because I have to complete my work in today itself and did not know how to make it possible. I was not expected that anyone will reply me so quickly. You saved my life. Thank you very very much. Aarif "Leo Heuser" wrote: Sorry, it should of course be: In A2: 50000 In B2: =A2/100 Format B2 with 2 decimals. Leo Heuser "Leo Heuser" skrev i en meddelelse ... "aarif" skrev i en meddelelse ... Dear all, I do have a file containing cheques value as by encoded it shows figures in dollers & sents without decimal points. I want to convert it to value with decimal points. value value to be converted into 50000 500.00 I tried by formatting it to Number with 2 decimal points by it adds 2 more Zeros and value looks 50000.00. I tried a lot but nothing happening please help me. Thanks in advance, Aarif Hello Aarif You can't do it with formatting. Formatting doesn't change the underlying value, it just displays it in different clothings so to speak. Try this setup: In A2: 50000 In B2: =A2/2 Format B2 with 2 decimals. -- Best regards Leo Heuser Followup to newsgroup only please. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Match then lookup | Excel Worksheet Functions | |||
Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Creating a check mark box | Setting up and Configuration of Excel | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) |