Prev Previous Post   Next Post Next
  #4   Report Post  
Jay
 
Posts: n/a
Default

I have a column of numbers. I want to add "shercs" to them all w/o
having to type the whole column over. Is this possible


One way is to use:
Format cells Number Custom
And put something like this in the "Type"
#,##0.00 "shercs"

This changes the display of the numbers, but the cells still are numeric.
So you can use them in arithmetic formulas.
 
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
Adding text in formulas Andreas Excel Worksheet Functions 2 July 11th 05 12:07 PM
Formulas dealing with text data Bagia Excel Worksheet Functions 6 June 20th 05 10:29 PM
Adding a lot of text to MS Excel cells macaleer16 Excel Discussion (Misc queries) 2 March 25th 05 02:31 PM
Adding two text cells together Audrey Excel Discussion (Misc queries) 4 February 24th 05 09:57 PM
Adding Leading Zeros to Text Jenn Excel Discussion (Misc queries) 4 January 12th 05 06:51 PM


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