Posted to microsoft.public.excel.worksheet.functions

pat67

external usenet poster

Posts: 48

formatting a percentage in a cell

I am trying to show this in a cell: 83% Complete

The 83% is from a vlookup and I concatenate with the word "Complete".
Problem is that when i do this the % becomes the actual value
0.832458... How can i make it so it stays a percentage?

Thanks

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
formatting as percentage	pat67	Excel Worksheet Functions	0	August 4th 11 02:00 PM
Formatting Percentages/LOOKUP using a Percentage	eed	Excel Discussion (Misc queries)	1	September 10th 09 07:07 AM
conditional formatting on sales percentage	Loadmaster	Excel Worksheet Functions	1	August 17th 09 03:11 AM
Percentage formatting	HJ	Excel Discussion (Misc queries)	1	March 17th 06 03:07 PM
Formatting percentage signs in Excel	Romany	Excel Discussion (Misc queries)	3	June 1st 05 07:02 PM

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

About Us

"It's about Microsoft Excel"

Menu

About Us