Joined: Fri May 29, 2009 10:41 am Posts: 25 Location: Milton Keynes, UK
Excel - Custom Number Formats
Custom number formats are used to change the way that the contents of a cell is displayed. (The cell format does not affect the actual contents of the cell).
You can find this option on the Menu Bar Format>Cells... or Right Click of the mouse or <Ctrl> + <1>. Then choose the Number tab and select the Category Custom.
The cell format is made up of 4 sections seperated by a semicolon (;) Positve Values;Negative Values;Zero Values;Text
Please feel free to add any that you can think of that are not already listed.
_________________ Damo
Last edited by Damo on Wed Jun 10, 2009 10:38 am, edited 3 times in total.
Mon Jun 01, 2009 3:08 pm
Damo
Site Admin
Joined: Fri May 29, 2009 10:41 am Posts: 25 Location: Milton Keynes, UK
Excel - Examples of Custom Number Formats
00000 - Always display 5 digits 0;-0;;@ - suppress zeros ;;;@ - suppress any numeric value
Users browsing this forum: No registered users and 1 guest
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot post attachments in this forum
