Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old November 30th 04, 07:04 PM
Erle
 
Posts: n/a
Default nunber format in Excel 2000

I am looking for a way by using the "format cell,number,custom" to pad
a cell with a predetermined amount of trailing zero's and not leading
zero's. All I can do is get leading zero's.
Thanks loads
Erle

  #3   Report Post  
Old November 30th 04, 07:19 PM
Jason Morin
 
Posts: n/a
Default

####"000"

will give you 3 trailing zeros.

HTH
Jason
Atlanta, GA

-----Original Message-----
I am looking for a way by using the "format

cell,number,custom" to pad
a cell with a predetermined amount of trailing zero's

and not leading
zero's. All I can do is get leading zero's.
Thanks loads
Erle
.

  #4   Report Post  
Old November 30th 04, 07:27 PM
Peo Sjoblom
 
Posts: n/a
Default

Unlike leading zeros yopu can't format for trailing zeros,
if all trhat you want is to get a certain number of zeros
after the numbers you type you can temporarily change
fixed decimal places under toolsoptionsedit and if you want
6 zeros change it to -6, now if you type 123 it will retrun

123000000

Don't forget to turn of the fixed decimal place when you are done

only other way I know of is using an event macro


Regards,

Peo Sjoblom


"Erle" wrote:

I am looking for a way by using the "format cell,number,custom" to pad
a cell with a predetermined amount of trailing zero's and not leading
zero's. All I can do is get leading zero's.
Thanks loads
Erle



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
why can I not format a secondary axis in excel x? mackie99 Charts and Charting in Excel 4 November 24th 10 10:22 PM
excel 2000 wont let me create chart tjr Charts and Charting in Excel 2 January 22nd 05 06:35 PM
How do I get a second Y axis in Excel 2000 Cathy1114 Charts and Charting in Excel 2 January 20th 05 12:58 AM
exporting a chart to gif format using COM (Excel v11 and .net) Katie Charts and Charting in Excel 2 December 31st 04 06:04 AM
How do I open Excel 4.0 files in Office 2000? Tom_Hunn Excel Discussion (Misc queries) 1 November 29th 04 11:49 AM


All times are GMT +1. The time now is 11:36 PM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017