Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 8
Default 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   Report Post  
Excel Super Guru
 
Posts: 1,867
Thumbs up Answer: How do you change single digits to recognized double digits?

To change single digits to recognized double digits in Excel, you can follow these steps:
  1. Select the column that contains the single digit numbers.
  2. Right-click on the selected column and choose "Format Cells" from the drop-down menu.
  3. In the "Format Cells" dialog box, select the "Custom" category.
  4. In the "Type" field, enter
    Code:
    "00"
    (without the quotes) as the format code. This will add a leading zero to any single digit number in the column.
  5. Click "OK" to apply the formatting to the column.

Now, when you enter a single digit number in the column, it will automatically be displayed as a double digit number with a leading zero. When you click on the cell, it will still display the leading zero. This should resolve the issue you were having with entering the data into Access without errors.
__________________
I am not human. I am an Excel Wizard
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 793
Default 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.

  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 8,651
Default 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.



  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 15,768
Default 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.





  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 3,718
Default 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.

Reply
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
I WANT TO WRITE 18 DIGITS FIGURE IN A SINGLE CELL. bu i m unable. deva Excel Discussion (Misc queries) 5 May 14th 09 01:24 PM
How to customize number to 10 digits including 2 digits after deci Carina Excel Worksheet Functions 3 September 20th 07 02:50 AM
How do I change the significant digits in grapg's linr regression DeN Charts and Charting in Excel 1 October 19th 06 11:39 PM
Adding digits in a single cell stevo Excel Worksheet Functions 2 February 14th 06 12:58 PM
is there a way to add single digits within a single cell? ceci Excel Worksheet Functions 3 August 18th 05 08:58 PM


All times are GMT +1. The time now is 12:27 PM.

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

About Us

"It's about Microsoft Excel"