Home |
Search |
Today's Posts |
|
#1
|
|||
|
|||
OT OT Excel ??????
"®óñ© © ²°¹°-°³" wrote in message ... On Sun, 29 Jul 2007 17:16:17 +0200, "David \(Normandy\)" wrote and included this (or some of this): "Frank Booth Snr" wrote in message .. . ®óñ© © ²°¹°-°³ wrote: On Sun, 29 Jul 2007 09:24:00 +0100, "'Mike'" wrote and included this (or some of this): 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? '067 will show as 067. It will however be text, not a number. As the guy said you simply type a single apostrophe before the number you wish to format as text. Eg '456.88. No need to bother with format menus. Strongly disagree. The problems with just using a single apostrophe to force numbers to be text occur when you try to sort the column. Things end up in the wrong place as you are mixing numbers and text. It can also lead to computational errors depending on how complex the spreadsheet is. So don't try to use numbers and text in the same column. If Mike wants to sort a text column, he inputs a text column and nothing else. And he keeps numbers in a separate column. What's the problem? -- ®óñ© © ²°¹°-°³ I think you've missed the point. It looks like Mike wants to insert text that look like numbers, for example telephone numbers. They all go into the one column. However telephone numbers aren't 'numbers' they are text, so either the column should be formatted as such or he would need to put a single apostrophe before every single entry to keep them consistent. Mixing numbers and text in the same column is a bad idea. David. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Flourish Excel and Press. CO2.... Redundant? | Freshwater Aquaria Plants | |||
Using Flourish Excel instead of CO2 ... not that expensive ... | Freshwater Aquaria Plants | |||
Using Flourish Excel instead of CO2 ... not that expensive ... | Freshwater Aquaria Plants | |||
Flourish Excel and Press. CO2.... Redundant? | Freshwater Aquaria Plants | |||
Flourish Excel as carbon source | Freshwater Aquaria Plants |