Posted to microsoft.public.excel.worksheet.functions

external usenet poster

Posts: 1

setting fixed decimals in only one column of worksheet

i want to set 1-2 column's in worksheet to fixed decimals. The only way i
have found is tools-options-edit and set decimal. this changes all future
data for the sheet to be set in this manner. I want to enter quanity x price
= cost. i want quanity without decimals and the other column's with fixed
decimals.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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
keep column fixed	conor wardie	Excel Discussion (Misc queries)	1	November 2nd 06 01:19 PM
Fixed decimals worksheet specific	Charlotte	Excel Worksheet Functions	7	September 14th 06 02:33 PM
How do I keep fixed and Non-fixed decimals on a sheet together?	kpike	Excel Worksheet Functions	2	June 22nd 06 12:33 AM
fixed decimals	GreenThumb	Excel Worksheet Functions	7	April 15th 05 12:35 AM
Bug - Decimals in Excel Worksheet	Ian	Excel Discussion (Misc queries)	2	February 15th 05 03:50 PM

All times are GMT +1. The time now is 11:34 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us