# Re: Formula Help

• From: Gord Dibben <gorddibbATshawDOTca>
• Date: Sat, 12 Aug 2006 08:50:15 -0700

Without formulas..................

Enter 100 in an unused cell.

Copy that cell.

Select your other numbers and Paste Special>Divide>OK>Esc.

Dekete the cell with 100

Gord Dibben MS Excel MVP

On Sat, 12 Aug 2006 01:47:02 -0700, aarif <aarif@xxxxxxxxxxxxxxxxxxxxxxxxx>
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" <leo.heuser@xxxxxxxxxxxxxxxxxxx> skrev i en meddelelse
news:OAi7ZbevGHA.3936@xxxxxxxxxxxxxxxxxxxxxxx
"aarif" <aarif@xxxxxxxxxxxxxxxxxxxxxxxxx> skrev i en meddelelse
news:B3024B4C-1E55-474E-A209-AB219CEDBA7A@xxxxxxxxxxxxxxxx
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
help me.

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

.

## Relevant Pages

• Asking too much of Excel?
... If the reference cell is formatted as text this equation works for any ... integers now but fails for decimals with a trailing zero. ... Every attempt I've made with formatting the cell drops the "insignificant" ...
(microsoft.public.excel.worksheet.functions)
• Re: Asking too much of Excel?
... If the reference cell is formatted as text this equation works for any number of decimals but fails for whole numbers. ... Every attempt I've made with formatting the cell drops the "insignificant" zero at the end of my decimal and gives me the result for the single decimal input. ...
(microsoft.public.excel.worksheet.functions)
• Re: percentage question
... If you want to round to the nearest 1%, that is 2 decimal places, so change ... and is formatted as percentage with 0 decimals. ... But when I take that percentage and multiply it by another cell to ... Perhaps if you remove all formatting and look at your numbers, ...
(microsoft.public.excel.misc)
• Re: pound signs cell formatting
... when I formatted it for number, any number of decimals didn't make it ... even grid in the body of the sheet. ... I can't make the cell larger ... I've already tried formatting it ...
(microsoft.public.excel.misc)
• Re: Formula Help
... Thanks a lot for helping me and for helping so quickly because I have to ... "Leo Heuser" wrote: ... Format B2 with 2 decimals. ... You can't do it with formatting. ...
(microsoft.public.excel.worksheet.functions)