LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 217
Default Percentages and formatting cells

Hi all

When I enter a figure into a cell and click onto the % icon, it doesn't
simply add a % sign at the end of the figure, it changes it into something
else altogether - what is it doing?

Also, if I then delete the figure and enter another one, it does just put
the % at the end of the figure.

Can anybody explain exactly what the icon is doing to the formattin of the
cell?

Thank you.
Louise
 
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
Help on a function with Conditional Formatting nemadrias Excel Worksheet Functions 1 August 10th 06 08:55 PM
Nesting IF statements, Conditional Formatting Nick Danger Excel Discussion (Misc queries) 2 September 26th 05 10:31 PM
Percentages quiddity Excel Discussion (Misc queries) 1 September 13th 05 05:03 PM
Counting coloured cells amvena Excel Discussion (Misc queries) 2 August 19th 05 02:40 PM
Calculate percentage based on cells with conditional formatting Cachod1 New Users to Excel 5 April 4th 05 02:11 PM


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

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

About Us

"It's about Microsoft Excel"