Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old July 3rd 08, 02:35 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2008
Posts: 2
Default How to make a cents symbol in Excel 2007

I read a comment about using Alt + 0162 to make a cents symbol (c with a
slash through it). But it was for Excel 2003. I tried it in Excel 2007 and
just got beeps for an error. How do you do it in 2007?
--
Scott in Salt Lake

  #2   Report Post  
Old July 3rd 08, 02:43 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Nov 2007
Posts: 44
Default How to make a cents symbol in Excel 2007

"Scott Salt Lake" wrote in message
...
I read a comment about using Alt + 0162 to make a cents symbol (c with a
slash through it). But it was for Excel 2003. I tried it in Excel 2007
and
just got beeps for an error. How do you do it in 2007?
--
Scott in Salt Lake


It should work in any program, Alt-0162 is the code to display a cents
symbol in most common fonts.

Are you using a font that uses this code for something else? Try using a
common font like Arial and see if it works.


  #3   Report Post  
Old July 3rd 08, 02:48 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 10,594
Default How to make a cents symbol in Excel 2007

Works fine for me in 2007 Scott, must be something in your setup.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Scott Salt Lake" wrote in message
...
I read a comment about using Alt + 0162 to make a cents symbol (c with a
slash through it). But it was for Excel 2003. I tried it in Excel 2007
and
just got beeps for an error. How do you do it in 2007?
--
Scott in Salt Lake



  #4   Report Post  
Old July 3rd 08, 02:54 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2008
Posts: 2
Default How to make a cents symbol in Excel 2007

I can't type in the number. When I press down the Alt key (and hold it down)
and then try to type the number 0162, it just beeps. I can't enter in the
number.
--
Scott in Salt Lake


"Lorne" wrote:

"Scott Salt Lake" wrote in message
...
I read a comment about using Alt + 0162 to make a cents symbol (c with a
slash through it). But it was for Excel 2003. I tried it in Excel 2007
and
just got beeps for an error. How do you do it in 2007?
--
Scott in Salt Lake


It should work in any program, Alt-0162 is the code to display a cents
symbol in most common fonts.

Are you using a font that uses this code for something else? Try using a
common font like Arial and see if it works.



  #5   Report Post  
Old July 3rd 08, 03:02 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: May 2007
Posts: 115
Default How to make a cents symbol in Excel 2007

Scott wrote on Thu, 3 Jul 2008 06:54:05 -0700:

I can't type in the number. When I press down the Alt key
(and hold it down) and then try to type the number 0162, it
just beeps. I can't enter in the number.
--
Scott in Salt Lake


"Lorne" wrote:


"Scott Salt Lake"
wrote in message
...
I read a comment about using Alt + 0162 to make a cents
symbol (c with a slash through it). But it was for Excel
2003. I tried it in Excel 2007 and just got beeps for an
error. How do you do it in 2007? -- Scott in Salt Lake


It should work in any program, Alt-0162 is the code to
display a cents symbol in most common fonts.

Are you using a font that uses this code for something else?
Try using a common font like Arial and see if it works.



Do you have a number pad on your keyboard? The numbers along the top
don't work. With a lap top you might have to lock in the numbers.

--

James Silverton
Potomac, Maryland

E-mail, with obvious alterations: not.jim.silverton.at.verizon.not



  #6   Report Post  
Old July 3rd 08, 03:12 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Mar 2007
Posts: 2,819
Default How to make a cents symbol in Excel 2007

Are you using the keypad, it doesn't work from the number row.

Scott Salt Lake wrote:

I can't type in the number. When I press down the Alt key (and hold it down)
and then try to type the number 0162, it just beeps. I can't enter in the
number.




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
Make Excel 2007 work like 2003 jgcwustl New Users to Excel 1 January 28th 08 10:50 PM
how to make excel 2007 open 2 wokbooks in 2 different windows Ofer Gal Excel Discussion (Misc queries) 1 May 5th 07 09:29 AM
My Excel totals are always 1 or 2 cents too low. Any ideas? Andyb Excel Discussion (Misc queries) 2 November 17th 06 09:59 PM
what symbol should i put in the formula to make a cell constant? emreak81 Excel Discussion (Misc queries) 1 July 14th 06 03:14 PM
Rounding to nearest 5 cents in excel usnst Excel Worksheet Functions 3 January 17th 06 01:27 AM


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

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017