Avatar
Please consider registering
Guest
Search
Forum Scope


Match



Forum Options



Minimum search word length is 3 characters - maximum search word length is 84 characters
Register Lost password?
sp_Feed sp_topic_old
XP Office
Avatar
peteski
Member
Members
Forum Posts: 11
Member Since:
October 5, 2008
sp_UserOfflineSmall Offline
1
October 5, 2008 - 10:22 am
sp_Permalink sp_Print

I'm having some trouble with Excel. I'm using XP Office and using Excel for documenting all my expenses. On the bottom of the page I have a row that I put in my mileage for medical travel. How can I make the one row show only mileage and not to show up as dollars and cents? Thanks in advance for any help. peteski

Avatar
Carol Bratt
Mod
Moderators
Forum Posts: 67
Member Since:
August 11, 2011
sp_UserOfflineSmall Offline
2
October 5, 2008 - 12:37 pm
sp_Permalink sp_Print

It's all about formatting Pete. Numeric formats change the display of data in a cell without changing the value of the data. Although formats can be applied while keying in your data, data entry may be simplified by entering raw figures that can then be formatted to include a dollar sign, comma, decimal places, percent sign, etc.

To apply a numeric format follow the steps below:

[list:bsqjyduc]Select the cell(s) to be formatted.
Click on [b:bsqjyduc]Format | Cells [/b:bsqjyduc]or right-click on the selection and click on Format | Cells.
Click on the [b:bsqjyduc]Number [/b:bsqjyduc]tab of the [b:bsqjyduc]Format Cells [/b:bsqjyduc]dialog box that appears.
Select a format category from the [b:bsqjyduc]Category [/b:bsqjyduc]list box.
Select a format from the Type list box, if applicable.
Select any other options that are applicable
Click OK.[/list:u:bsqjyduc]

In the attached screenshot, I formatted the Expense cells as Currency and then just entered raw data which then had a dollar sign and decimal added automatically.

For the Gas Mileage cell I formatted it as text. Text formatted cells are treated at text even if a number is entered into those cells. The cells is displayed exactly as it is entered.

Please also note the formula I created for the Total of the Expenses.

I hope this has answered your question. If not, let me know!

Avatar
peteski
Member
Members
Forum Posts: 11
Member Since:
October 5, 2008
sp_UserOfflineSmall Offline
3
October 20, 2008 - 9:38 pm
sp_Permalink sp_Print

Thanks a bunch, Carol. I guess the "Polack" in me really has shown. I knew it had to be something simple. I really appreciate your help.
Peteski Karczmarczyk

Forum Timezone: America/Indiana/Indianapolis
Most Users Ever Online: 2303
Currently Online:
Guest(s) 17
Currently Browsing this Page:
1 Guest(s)
Top Posters:
Chad Johnson: 867
Mindblower: 701
carbonterry2: 356
Flying Dutchman: 278
grr: 211
Newest Members:
kem10
Norajohnson
sunny01
snave53
daleoS
Forum Stats:
Groups: 8
Forums: 20
Topics: 1974
Posts: 13651

 

Member Stats:
Guest Posters: 11
Members: 3258
Moderators: 7
Admins: 3
Administrators: Jim Hillier, Richard Pedersen, David Hartsock
Moderators: Carol Bratt, dandl, Jason Shuffield, Jim Canfield, Terry Hollett, Stuart Berg, John Durso
Scroll to Top