Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
nastech
 
Posts: n/a
Default SCRIPT: custom formatting

Would a script be ok for Custom Formatting:
(as otherwise would be: rightclick cell, format cells, Number tab, custom)
i.e.: NOT able to use a formula, (NO Formula's)

Hi, looking for way to omit characters (numbers) in custom format where
examples might be: 1.5M 1.5B and/or 1.51BM 1.51B thanks.

to allow something like?: (not sure what correct version should be)
#,##0? ("?" for any alpha-character)
0?
#?
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
Custom Formatting Nikki Excel Worksheet Functions 2 February 13th 06 09:10 PM
Custom Formatting Gary''s Student Excel Worksheet Functions 0 February 13th 06 08:36 PM
Formatting custom currency quirk jds217 Excel Discussion (Misc queries) 2 February 10th 06 05:38 PM
custom formatting ???/???? DVR019 Excel Discussion (Misc queries) 2 June 4th 05 11:07 AM
Custom Cell Formatting and Calucations Kim CB Excel Worksheet Functions 5 May 26th 05 07:49 PM


All times are GMT +1. The time now is 02:43 PM.

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

About Us

"It's about Microsoft Excel"