LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #12   Report Post  
Old 29-07-2007, 11:21 AM posted to uk.rec.gardening
external usenet poster
 
First recorded activity by GardenBanter: Jul 2006
Posts: 139
Default OT OT Excel ??????

On 29 Jul, 09:24, "'Mike'" wrote:
I wish to put numbers in a cell which commence with a '0'. For example 067
but when I go to the next cell, the number reverts to just 67.

I can get over it by putting an 'O' (capital o), but this then does not Data
Sort properly.

Can anyone help please?


All you need to do is create a custom format. Select the cells, then
format-cells - Number - select Custom - then (for example) type in
000000 as a format.

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Flourish Excel and Press. CO2.... Redundant? 350X_Rider Freshwater Aquaria Plants 2 02-04-2003 03:33 PM
Using Flourish Excel instead of CO2 ... not that expensive ... Harry Muscle Freshwater Aquaria Plants 2 02-04-2003 03:33 PM
Using Flourish Excel instead of CO2 ... not that expensive ... 350X_Rider Freshwater Aquaria Plants 0 27-03-2003 01:32 PM
Flourish Excel and Press. CO2.... Redundant? 350X_Rider Freshwater Aquaria Plants 0 27-03-2003 01:32 PM
Flourish Excel as carbon source Henry Freshwater Aquaria Plants 17 08-03-2003 02:23 PM


All times are GMT +1. The time now is 05:15 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 GardenBanter.co.uk.
The comments are property of their posters.
 

About Us

"It's about Gardening"

 

Copyright © 2017