number formats and masks

M

mike

Hi - I have a list of numbers whose formats i need to
change. For example, the number 79.26 shows up in my
formula bar as 79.25999999. How do I make all those 9's
go away?
 
B

Bob Phillips

Mike,

Format as a number to 2 dec places, menu Format>Cells and so on.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
M

mike

Bob,
thanks, but it doesn't work. Though the number displays
and prints to two decimal places, the actual contents of
the cell is the larger number 79.2599999999. Its
troublesome for me because I'm converting my excell file
to text and importing it into my accounting system and its
showing up there out of balance.
 
P

Peo Sjoblom

Use 2 decimal places and precision as displayed under
tools>options>calculations,
the drawback is that it affects all decimals, otherwise you could use a help
column and round

=ROUND(A2,2)

copy down/across, copy and paste special as values in place and use the help
column instead.
There might still be some discrepancies due to the way excel and other
programs handle the decimals
but with some Andersen book keeping surely a few pennies can disappear <g>

for explanation and workarounds see

http://www.mcgimpsey.com/excel/pennyoff.html

for a very pedagogic description
 
B

Bob Phillips

Mike,

Okay, if you actually want 79.26 rather than just see it, you have to get
that value in another cell, such as in B1
=ROUND(A1,2)

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
M

Mike

Perfect. Many thanks. Its exactly what I needed.
-----Original Message-----
Mike,

Okay, if you actually want 79.26 rather than just see it, you have to get
that value in another cell, such as in B1
=ROUND(A1,2)

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)




.
Click to expand...
 
Top