Decimal place and rounding off issue

  • Thread starter Thread starter Naomi
  • Start date Start date
N

Naomi

hello

hoping for some help if possible please :o)

I'd like my work sheet to stop doing a couple of things but not sure which
function
controls this...

First Issue

I type into a cell: 345.20

it changes it to: 345.2

I'd really like the figures to never change from what I have entered,
leaving my zero in place.

Second Issue

It rounds off the figure to fit in the cell if the column isn't wide enough,
this usually throws out my end figure by a few cents.(temp fix I used for
that was expanding the columns)

Is there a setting that controls a column to expand automatically when the
cell entry is wider then the column?

Looking forward to any advice :o)

Cheers Naomi
*from Australia, sorry about the time stamp*
 
your a legend Mr Harker thank you for your prompt reply, it worked a treat

hope I am not being too cheeky asking you to take a look at my newer post

Cheers Naomi

: Hi Naomi!
:
: Both issues should be resolved by:
:
: Format > Cells
: Number Tab
: Number
: Set decimal places to 2
: OK
 
Hi Naomi!

Thanks for thanks. It looks like another legend has already answered
your second post; dinner and a short nap and the English cavalry have
appeared over the Purbecks galloping to the rescue.

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
Holidays and Observances Sunday 20th July: Bulgaria (St. Elijah’s
Day), Colombia (Independence Day), North Cyprus (Peace and Freedom
Day), Italy (Festa del Redentore), Japan (Marine Day), Norway
(Birthday of Crown Prince Haakon), Solomon Islands (Special Holiday
Renbel Province), USA (Moon Day).
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Back
Top