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 |
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) |