Posted to microsoft.public.excel.worksheet.functions

Stan Atshuller Stan Atshuller is offline

external usenet poster

Posts: 1

Format % Question

I have a number in percent format 5% I need it to be displayed as 5 with out
changing the formula. Excel multiplies by 100 and then add the % sign, I
need it to multiply by 100 and not add the % sign.
Is this possible?
Thanks!
Stan

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
Date Format question	Aaron	Excel Discussion (Misc queries)	3	April 5th 06 01:51 PM
Date format Question	Fable	Excel Discussion (Misc queries)	1	December 1st 05 01:18 PM
Conditional format question	[email protected]	Excel Discussion (Misc queries)	7	September 16th 05 04:15 PM
Simple Format Question	Ket	Excel Worksheet Functions	1	March 2nd 05 04:10 PM
Date Format Question	Josh O.	Excel Discussion (Misc queries)	1	February 10th 05 09:45 PM

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

About Us

"It's about Microsoft Excel"

Menu

About Us