LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 407
Default cusotm formats

I have a bunch of custom formats that I use that were created by others.
They have many symbols in them hyphens, #, etc, etc.

I also have learned how to have a number displayed with say "total =" in
front of it, but I only know how to do that for simple formats, such as an
integer. I tried modifying one of those custom formats with "total =" and a
spacebar in front of them, similar to how I use "total =" 0, when it is an
integer. But it did not work. So, the question is, if I want to modify an
existing custom format but just want to put some text in front of it, how do
I do that?

Thanks!
Dean


 
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
Conditional Formats, how to scroll and view all formats? Bill E Excel Worksheet Functions 0 May 12th 10 07:58 PM
Copying formats - column widths, formats, outlining to worksheets DavidBr318 Excel Worksheet Functions 4 August 14th 09 05:03 AM
Conditional formats- paste special formats? jcarney Excel Discussion (Misc queries) 1 November 1st 07 06:37 PM
paste conditional formats as formats leo Excel Discussion (Misc queries) 2 July 5th 07 10:06 AM
Formats: Too many different cell formats error message [email protected] Excel Programming 3 February 1st 05 01:34 AM


All times are GMT +1. The time now is 09:37 AM.

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"