Thread: Formula Help
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
aarif aarif is offline
external usenet poster
 
Posts: 8
Default 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