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: 249
Default Changing number format to remove %

I have a formatting problem

I have cells with a general format so when i type something it comes out as
typed.

However...

If I type a % number in for example 50%. If I retype text into the same cell
afterwards it come out as text%, retaining the percentage format.

Even when I reapply the general format from the format cells dialog, or use
the format painter, the % doesnt go away. I have to manually select the text
and delete the % sign.

Can anyone offer help on how to revert the cells back to general format to
stop the percentage format dominating when it is used?

Thanks,

Roger
 
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
Changing number format gcotterl Excel Worksheet Functions 0 July 17th 06 08:50 AM
How to remove Hyperlink without changing cell format? JAB Excel Worksheet Functions 1 January 20th 06 07:08 PM
Changing Number Format Howard Kaikow Excel Programming 3 December 28th 05 09:53 AM
Changing format of number without changing the value sweetsue516 Excel Discussion (Misc queries) 2 August 22nd 05 04:07 PM
Changing a cell's number format Chris Excel Programming 3 May 17th 05 08:31 PM


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