Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old May 17th 05, 06:43 PM
Bill R
 
Posts: n/a
Default Manipulate an excel column

How do I add leading zeroes to data within an excel column. I'm trying to
convert data into total of 5 numerics by adding leading zeroes into the
string.

  #2   Report Post  
Old May 17th 05, 06:59 PM
LanceB
 
Posts: n/a
Default

format

use custom format
enter
00000

Lance

"Bill R" wrote:

How do I add leading zeroes to data within an excel column. I'm trying to
convert data into total of 5 numerics by adding leading zeroes into the
string.

  #3   Report Post  
Old May 17th 05, 07:01 PM
Duke Carey
 
Posts: n/a
Default

Two ways:

If you want only to DISPLAY 5 digit values, use a custom format: 00000

If you really need 5 digit values, AND WORKING ON A COPY OF YOUR DATA,
insert a column temporarily, adjacent to your data. So, if your data is in
col A, insert a new col B. In the new cells use the formula:

=text(A1,"00000")

Copy it to all the pertinent cells
Select all these formulas & copy them
Select the original cells and use EditPaste SpecialValues
Delete the temporary column

"Bill R" wrote:

How do I add leading zeroes to data within an excel column. I'm trying to
convert data into total of 5 numerics by adding leading zeroes into the
string.



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
Excel should provide an easy way to switch a column into a row, n. samsson Excel Discussion (Misc queries) 2 March 21st 05 04:20 PM
Excel countif based on size of numbers in one column in Access Kristjan_Thor Excel Worksheet Functions 3 March 17th 05 10:21 PM
Create an if-then formula in Excel to limit column total? Nancy M Excel Discussion (Misc queries) 2 February 13th 05 10:47 PM
Column A is Town, Column B is names. How can Excel add & tell how. Cindy Charts and Charting in Excel 3 January 13th 05 07:27 PM
How do I sort a column of formulas in Excel? Gordon Excel Discussion (Misc queries) 2 November 27th 04 01:55 AM


All times are GMT +1. The time now is 06:58 PM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017