If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
How do you change single digits to recognized double digits?
I asked earlier how to make a column display a two digit number instead of a
single digit number (under 10) by adding a zero in front. The answer was to hit custom and type in two zeros. The problem is the spreadsheet does display the 02 on the cell but if you click the cell it still reads ony the 2. This doesn't allow me to enter into access without errors. I have tried copy paste special but still does not resolve the issue. Any help would be appreciated. Bottom line I need to be able to place a 0 in front of all single digit numbers in a column. Thanks. |
#2
|
|||
|
|||
How do you change single digits to recognized double digits?
As long as cells contain numbers, leading zeroes will not be stored in the
cell... You may convert them to text with soemthing like this in B1 =IF(Len(A1)=1, "0&A1",""&A1) and copying down, then copy-paste as values, assuming your numbers are in Col A Ideally you shuold handle this conversion while importing in Access. "Evil with a K" wrote: I asked earlier how to make a column display a two digit number instead of a single digit number (under 10) by adding a zero in front. The answer was to hit custom and type in two zeros. The problem is the spreadsheet does display the 02 on the cell but if you click the cell it still reads ony the 2. This doesn't allow me to enter into access without errors. I have tried copy paste special but still does not resolve the issue. Any help would be appreciated. Bottom line I need to be able to place a 0 in front of all single digit numbers in a column. Thanks. |
#3
|
|||
|
|||
How do you change single digits to recognized double digits?
=TEXT(A2,"00")
-- David Biddulph Evil with a K wrote: I asked earlier how to make a column display a two digit number instead of a single digit number (under 10) by adding a zero in front. The answer was to hit custom and type in two zeros. The problem is the spreadsheet does display the 02 on the cell but if you click the cell it still reads ony the 2. This doesn't allow me to enter into access without errors. I have tried copy paste special but still does not resolve the issue. Any help would be appreciated. Bottom line I need to be able to place a 0 in front of all single digit numbers in a column. Thanks. |
#4
|
|||
|
|||
How do you change single digits to recognized double digits?
As you've discovered, number formatting is for *display purposes only*. The
true underlying value of the cell may not be what is *displayed*. So, you'd need to either preformat the cells as TEXT or precede the entry with an apostrophe like this: '02. The apostrophe will not be displayed in the cell. -- Biff Microsoft Excel MVP "Evil with a K" wrote in message ... I asked earlier how to make a column display a two digit number instead of a single digit number (under 10) by adding a zero in front. The answer was to hit custom and type in two zeros. The problem is the spreadsheet does display the 02 on the cell but if you click the cell it still reads ony the 2. This doesn't allow me to enter into access without errors. I have tried copy paste special but still does not resolve the issue. Any help would be appreciated. Bottom line I need to be able to place a 0 in front of all single digit numbers in a column. Thanks. |
#5
|
|||
|
|||
How do you change single digits to recognized double digits?
=TEXT(A1,"00")
"Evil with a K" wrote: I asked earlier how to make a column display a two digit number instead of a single digit number (under 10) by adding a zero in front. The answer was to hit custom and type in two zeros. The problem is the spreadsheet does display the 02 on the cell but if you click the cell it still reads ony the 2. This doesn't allow me to enter into access without errors. I have tried copy paste special but still does not resolve the issue. Any help would be appreciated. Bottom line I need to be able to place a 0 in front of all single digit numbers in a column. Thanks. |
Thread Tools | |
Display Modes | |
|
|