Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
caroline argyle
 
Posts: n/a
Default putting leading zeros in front of number

I would like to display a number with leading zeros in front of it.
  #2   Report Post  
Andrea Jones
 
Posts: n/a
Default

Format the cell with a custom format such as

00000000

(this would put enough leading zeroes in front of the number to make it up
to 8 digits).

Andrea Jones
http://www.allaboutoffice.co.uk
http://www.stratatraining.co.uk
http://www.allaboutclait.com

"caroline argyle" wrote:

I would like to display a number with leading zeros in front of it.

  #3   Report Post  
FSt1
 
Posts: n/a
Default

hi,
you could create a custom format for it but numbers with leading zeros are
usually not real numbers, that is a number you would want to do something
mathmatical to.
ever had a reason to devide your zip code by 2?
for that reason i usually recomend that you just format it as text and treat
it as such.

Regards

FSt1

"caroline argyle" wrote:

I would like to display a number with leading zeros in front of it.

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
How do I force leading zeros in an Excel cell? EricKei Excel Discussion (Misc queries) 2 June 15th 05 08:28 PM
Leading zeros Paul Excel Discussion (Misc queries) 4 June 12th 05 04:04 AM
How do I display leading zeros so I can export a fixed in Excel? World Referee and accountant Excel Discussion (Misc queries) 2 January 3rd 05 05:18 PM
Adding + in front of a number Ted Metro Excel Discussion (Misc queries) 3 December 29th 04 11:45 PM
single quote 10-digit number that has leading zeroes & then conca. lorelei739 Excel Worksheet Functions 1 November 5th 04 01:02 AM


All times are GMT +1. The time now is 04:26 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"