Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old August 22nd 05, 05:46 PM
acsnett
 
Posts: n/a
Default when i enter a dollar amount of 18.40 into excel it drops the 0

can anyone help me fix this problem?

  #2   Report Post  
Old August 22nd 05, 05:50 PM
FSt1
 
Posts: n/a
Default

hi,
it would be better if you put your question in the body of your post and not
in the subject. your question is truncated so i am not sure exactly what your
question is.

Regards
FSt1

"acsnett" wrote:

can anyone help me fix this problem?

  #3   Report Post  
Old August 22nd 05, 05:56 PM
gls858
 
Posts: n/a
Default

acsnett wrote:
can anyone help me fix this problem?


Try formatting the cells as currency. Hight the cell or cells
right click select format in the numbers tab select currency.

gls858
  #4   Report Post  
Old August 22nd 05, 06:05 PM
David McRitchie
 
Posts: n/a
Default

Not having a complete statement of the problem in the body is indeed
confusing. Anyway I do see question without truncation on the
subject line. You have to fix the problem yourself by formatting
the cell. Select the cell, or preferably and entire column so you
have only one format and then use Format, cells, number
and make an appropriate choice with two decimal digits. You can
use the format buttons on your toolbars with the comma and the
increase/decrease decimal places.
http://www.mvps.org/dmcritchie/excel/formula.htm

format, cells, number
choose number of decimal places
choose whether you want a comma (may be a different char if not US/Canada)
choose the format such as red negative numbers with minus or in parens.

More choices under accounting.

You also have the toolbar formatting buttons.

You might also look at any choice you've made under
format, cells, custom -- to see how it was actually done

This is rather basic stuff so if that is not clear I would suggest you look
at a couple of tutorials.
http://www.mvps.org/dmcritchie/excel....htm#tutorials

---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"FSt1" wrote in message ...
hi,
it would be better if you put your question in the body of your post and not
in the subject. your question is truncated so i am not sure exactly what your
question is.

Regards
FSt1

"acsnett" wrote:

can anyone help me fix this problem?





Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
how do I enter more than one line in the same Excel Cell by using. vsimmons Excel Discussion (Misc queries) 12 January 3rd 09 01:04 AM
How do I enter a slash character in excel? michaelgreen Excel Discussion (Misc queries) 1 June 14th 05 02:22 AM
Excel Range Value issue (Excel 97 Vs Excel 2003) Keeno Excel Discussion (Misc queries) 2 June 13th 05 02:01 PM
How do i enter negative times in Excel & how can they be 'fiddled. stuck! Excel Discussion (Misc queries) 2 April 7th 05 02:05 PM
Excel - cursor moves to other cells after I enter data, without h. mitzi Excel Discussion (Misc queries) 2 March 2nd 05 04:22 AM


All times are GMT +1. The time now is 10:03 PM.

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
Copyright 2004-2021 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017