Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
s s is offline
external usenet poster
 
Posts: 36
Default How do you add three ending '0's to a column of numbers?

I am pretty sure I've Done this before but it does not work under the custom
format feature which what I thought I had used. Seems som simple, huh?

thanks,
s
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 5,939
Default How do you add three ending '0's to a column of numbers?

Try this custom format
0"000"
--
HTH...

Jim Thomlinson


"s" wrote:

I am pretty sure I've Done this before but it does not work under the custom
format feature which what I thought I had used. Seems som simple, huh?

thanks,
s

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
Can I change a column of calculated numbers to absolute numbers? Kate Bissell Excel Discussion (Misc queries) 3 October 25th 06 06:10 PM
Changing column of numbers made of formulas to just numbers CJ Excel Discussion (Misc queries) 2 June 14th 06 02:13 PM
Excel Formula - Add column of numbers but ignore negative numbers view for Distribution List members Excel Worksheet Functions 1 April 7th 06 03:13 AM
I want to sum a column and exclude those ending with cr cbanks Excel Worksheet Functions 5 October 5th 05 02:58 PM
Ending zero RAB Excel Discussion (Misc queries) 3 August 25th 05 06:09 PM


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